I have a project that I am working on that is an hours summary. I have created one workbook and want to have the first worksheet be my summary page. There will be perhaps as many as 200 worksheets that follow containing a list of dates and hours worked with a sum at the bottom. The length of these columns will vary on all the worksheets. What I WANT to do is to copy the sums from each of the worksheets to a specific cell on my summary sheet. I know this may sound simple, but I simply have not found a way to do this. I have attached the workbook.
Bookmarks