Auto populate data

Msolomon - Jan 20, 2017 at 12:49 PM
I have a workbook that has a tab for each week of the month. At the end I have a budget tab that I want certain information to auto populate into the budget. The spreadsheets for each week of the month can vary in length. In the D column I have categories of job titles: Bartender, Food Runner, and Server. In the corresponding rows in column I are total hours. I want any any hours associated with Bartender in all sheets to sum and populate in the budget sheet next to bartender, etc.

Is this possible?