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
---------------
Jacob Skaria


"teelee" wrote:

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?