I have a workbook that has 44 worksheets with a list of Employee Names, FTE,
Job Title and their Location.

I have to list all information on one worksheet at the end, so I can attach
their salaries and allowances for budget.

All worksheets are in the same format.

Location for all employees is D3 in all worksheet. and Emplyee names are
listed in rows B9 to B48, S4 to S26 and S29 to S52.Their FTE's are listed in
rows C9 to C48, U4 to U26 and U29 to U52. Job Title for employees listed in
rows B9 to B48 is in row B8. Job Title for employess rows S4 To S26, S29 to
S52 is listed in Rows R4 to R26 and R29 to R52.

Each worksheet might not have employees in all rows, some might have up to
40 employees and some as little as 8.

I have listed all information for each sheet in columns AA1 Name, AB1 FTE,
AC1 Job Title and AD1 Location, then on the last worksheet I did = for each
cell that containe data.

I was hoping that there might be an easier way.

Thanks
--
Newfie