I have a spreadsheet with multiple sheets labeled Summary, April through November 2017. For each month sheets, I have listings of each employees, titles, billing rates, hours and fee amount (billing rates x hours).
What I would like to do is in the summary sheet, I have created a chart with all employees names with their title, billing rates and fee amounts and would like to calculate each hours and fee amount across all sheets into this one chart.
If you can spell out the steps that I need to do this, that would be great.
Thanks for all your anticipated help.