Combining multiple excel document information (to use with Stata)

Hello everyone

I am working with the US IRS data from a previous year. Each state is its own excel file with information about various information for every zipcode that state contains. I am trying to combine the excel data from all the states into a single file.

I feel the most rudimentary way would be to copy and paste, but would take a very long time with 50 files. To make things more complicated, I would not "copy all" the data; I would only copy the headers and information underneath (excluding the miscellaneous information). So I would have to copy a selected portion to be pasted in a new file.

I am doing this to create a stata data set, but I first need to import the information from excel (as a .csv file) as a single file that has all of the 50 states data.

Any tips or tricks to make this process more efficient are much appreciated, thanks!

please let me know if my question needs any clarification, thanks