Hi,

I'm quite new to Stata so I am in a bit of a pickle. I need to get a long format firm-year panel done. I have all the raw data in excel sheets and this is the description of my excel sheets:

- 10 Excel Files
- Each File has multiple worksheets: AU, BG, CN, IN, etc
- Each region has 2 worksheets, one for each variable
- 2 variables in question: UP and NOSH
- Each excel file corresponds to a year and each of the AU_UP, AU_NOSH, BG_UP, BG_NOSH sheets have monthly data, so the column names are end of month dates (ex: 12/31/2010)

I am lost as to how to create a long format firm-year panel for these because the data is across multiple excel files and across multiple sheets. So each excel file has AU_UP and AU_NOSH monthly data for example, only for that particular year. I do not understand how I can cycle through these files and basically have stata append the 2011 AU_UP data to the end of the 2010 AU_UP data in another file and so on. Any sort of help would be amazing, thank you so much.