Copying rows from different excel files

[learningstatistics]

Hello,

I am trying to copy rows of numbers, each of which appears in one of 60 files I have. It looks something like that:

Number of employees

20

30

35

<tbody>
</tbody>

So excel file one has the row above. Excel file two has Number of employees 30 35 35 ... I have 60 files each with one relevant row. I just need to copy and paste each of those rows in one file.

The tedious way of doing this is starting a blank excel sheet, going to each one of the 60 files and copying the row from it. So that's 60 openings of files, 60 copyings, and 60 pastes.


Is there a more efficient way of doing this? .. What?

Thanks

 

[JLGWhiz]

If you would like to share with us the columns that your data is located in and the sheet name within each file containing the data, then maybe we can respond to your query with a meaningful suggestion. It will also be necessary to tell us how to recognize the applicable file if there are other files in the folder besides the ones containing the target data.