How do I move multiple tabs in multiple workbooks to a master?

T

teelee

I am in payroll. Each person has their own file with multiple tabs or
worksheets dated for each week. Each week I need to move that week's date
tab into a master workbook for multiple people. What is an easier way than
move or copy when you right click on the individual tab?
 
J

Jacob Skaria

The easiest way is to build a macro which will automatically move the sheets
to the master file..If you are looking for a VBA solution let us know
--master book name format
--individual workbook naming covention
--the sheet name format (week)
with examples..

If this post helps click Yes
 
T

teelee

Each city gets their own master (where I combine the muliple tabs or
worksheets each week), so I would name them ORL coversheets WE 10-2-09, or
HTX coversheets WE 10-2-09, etc.

The individual worksheets in each persons workbook are named 9-25-09,
9-2-09, etc. so just dates

The workbooks are named by the person or employee, so John Doe, etc.

Let me know if you need further information. Thank you so much for your
help!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a master workbook to carry over changes to multiple workbooks 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Macro to Format Multiple Sheets based on "Master" Format 0
How do I combine multiple tabs into one? 2
combining data from multiple workbooks 5
How to get range names to Apply across multiple tabs 1
How to update a value from a linked worksheet back to the master worksheet? 0
if able, how do you sort Tabs in excel (alpha-numeric) ?? 3

Top