I run a company where each "gig" is a separate worksheet and each worksheet contains the name of an employee on that gig and the amount paid to that employee for that gig.
How can I run a report (pivot table?) to identify the amount paid for each person when the data is listed across many worksheets?

Follow up question: Is it better to not store each gig as a separate worksheet, an store it some cleaner way on 1 worksheet. Not sure how I'd do that since each gig has multiple contractors I need to pay.