Merge Multiple Excel Sheets into One Sheet by auto10

I have about 8000 excel sheets that need to be combined into one sheet using the same header rows. The file name must be entered as a new column and applied to each row. (Budget: $10-$30 USD, Jobs: Data Entry, Data Processing, Excel)