Hi,

Check this link -
http://datapigtechnologies.com/blog/...od-2/#more-585

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"teelee" wrote in message
...
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?