Most basic way, I think there is an activity called Get sheets
Use it to get a list of sheets into a collection
Loop through the sheets and for each sheet,
Read Range by limiting the range to just get the first row into a Datatable.
Obviously, If the first row of the Datatable has names that you require, then you read the data from this sheet.
The jndex of the column will give you the position of each column
Hope this helps.