? Automatically Combining Data from Multiple Excel Sheets ?

**Brandon132** · 09-28-2013, 02:29 AM

Hey everyone,

I have a time tracker that provides hours that employees clock in and out. It provides me with an excel document with all the employees time every two weeks as needed, however it does not total the hours from all previous spread sheets so that I can have a YTD (year to date) total of the employees hours worked and I need to be able to have this. Currently I am going through each and every spreadsheet and totalling them up. I have over 40 employees and this has become very time consuming to say the least. Any suggestions?

Thanks in advance!

**FDibbins** · 09-28-2013, 02:46 AM

Hi and welcome to the forum

Not sure if this is what you are after, but give it a try...
if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though