I am trying to compile some data from many Excel workbooks to one workbook.
Ex, my payroll is entered weekly and contain project #'s, and employees. I
want to compile the project numbers and hours worked into one sheet. Any
suggestions would be appreciated.

Thanks