Create a single dataset from around 150 excel files that have the same format

Job ID: 31827097

Budget: $30 – $250 AUD

hi there.... there are about 150 excel files with data on NHS medicines on the site below available for free download. Each file has 2 sheets, and all sheets have the same column names. An example Excel file is attached
I'd like to have all this data combined and put in a single large excel sheet, initial example as per attached.
cheers
Anthony
https://www.nhsbsa.nhs.uk/prescription-data/dispensing-data/prescription-cost-analysis-pca-data
Related categories: Data Processing Excel Data Extraction Datatables