Find all instances and copy to new sheet??

I have a workbook with 26 sheeets. On each of the sheets is a Name and a Cost column amongst other data. I need on a new sheet a master list of every name that appears anywhere in the workbook along with the total of the Cost columns associated with that name. Is this possible? I am attaching the file. Thank you for any help!