I am wondering if there is an equivalent to the indirect function for worksheets or workbooks instead of cells. What I mean by that is I am updating a rather large and unwieldy workbook for payroll for a company that has all sorts of people at different hourly rates working on different projects. Each employee submits their payroll info for the month as an excel worksheet. What I want to do is automate the aggregation of each employees hours for each particular project as much as possible. If I could call a particular cell in a particular workbook without changing the formula every time that'd be great.

To put it another way, every month each employee submits their worksheet titled "Name Month". I want to compile these in a workbook and automatically pull the data for a summary page that will list the bills for different projects. I think I could do this if the indirect function could also be used for worksheets instead of just cells, but it can't. Is their an equivalent function?

I do not know VBA.

Thanks