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

  • Thread starter Thread starter teelee
  • Start date Start date
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?
 
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
 
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!!
 
Back
Top