I have a few worksheets in a workbook, one for each employee.

I want the lead worksheet to be a compilation of all data...same row/column for each worksheet.

Is there a function/method to copy on that lead in worksheet, so that cell position is the same but will copy across for each different tab (therefore each column becomes an employee)?

I am trying to avoid having to manually set the formula up for each tab on that lead in page.

Hope that makes sense...

Thx...Jeff