Pulling in data from multiple sheets

Options

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.

  1. Time Sheets
    1. There will be single-digit numbers of time sheets each month
    2. Managers fill out time for their employees buckets into projects and finance codes.
  2. Reporting Sheets
    1. One for each month
    2. Pulls data from each time sheet
    3. 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.



Answers