Return common values in multiple worksheets into one worksheet

I have a different worksheet in the same workbook for every "gig" that I book. Each gig contains the name of the musicians I staffed on the gig along with their salary+expenses
For taxes, I need to summarize into a new worksheet how much each musician made. Ideally i'd see not only the total per name but itemized. So if 1 guy did 3 diff gigs, I'd see each row pertaining to his name.

Lastly, I'd like to include names that do not have multiple records because it's possible there is inconsistencies with the spelling of certain names.

You mean you need to retrieve the duplicate data into one record?

Cheers

more than that.
Say I have a name Jon smith. I need to find all instances of Jon Smith across all workbooks, and then return all data in Jon Smith's row.

I prefer to not just have a total for Jon Smith returned but to be able to see every data point individually.

Maybe you have the sample workbook and upload it at the forum?

Thanks