Pulling in data from multiple sheets
I just finished making a time sheet project that works well but now I need to pull data in from the filled-out sheets into a summary.
- Time Sheets
- There will be single-digit numbers of time sheets each month
- Managers fill out time for their employees buckets into projects and finance codes.
- Reporting Sheets
- One for each month
- Pulls data from each time sheet
- Need to have totals for each finance code per department
I have attached example screenshots for the two sheets. This doesn't have to be completely automated (I don't mind tweaking a few things one a month) but I'm at a loss how to pull this many dimensions of data from multiple sheets and get them into the summary. Let me know if there are any other questions.