Combine multiple spreadsheets

[pwielgosh]

Hi,
I have an excel workbook that has over 20 sheets. Each sheet contains various information to name a few: sporting event, dates, names and dollar amounts and I would like to pull just a name and dollar amount for each person into one spreadsheet. The various sheets do not have the same names or dollar amounts in the same rows/colums. There are spaces throughout the worksheet. They are kind of all over the place. Sometimes new names are added so the names do not stay the same. Any suggestions on how to start?

 

[awoohaw]

If you have excel 2013 (and possible 2010) and later you can use Power Query to consolidate your worksheets in the built in data model.
Please take a look at you tube videos by Leila Gharani, Mr. Excel, MyOnlineTrainingHub, and ExcelISFun.
Take a look at this Playlist by MyOnlineTrainingHub:

https://youtube.com/playlist?list=PLmd91OWgLVSKnVrL0YxdOH61MAiqlFHac&si=s-ocfjxPqMpcIplu

Here is another for worksheets: