how to prepare one single spreadsheet to import data into target table?

[sai kaivalya]

I have 10 Excel sheets containing all the data, but we only need data from a few specific fields from each sheet. We need to consolidate this data into a new Excel spreadsheet, which will be uploaded when creating the source table. I would like to know the step-by-step process, along with an example, of how we can merge data from multiple Excel sheets into a single spreadsheet."

Thanks