Combine under Enterprise tab result returns as a Blank workbook

Question

I am trying to combine all the sheets of my workbook into one sheet.

I have multiple sheets with the same data format that I am wanting to combine, I followed the instructions to the letter, yet everytime I try to combine them, the new workbook is blank. I have tried multiple permutations of the combine options and all of them come back blank.

Is there something that I am fundamentally doing wrong, maybe there is something wrong with my data? Its just columns with Supplier name, category, item Name, Quantity, price and total. Each sheet is per supplier and using the same format.

I do get a Remark in the second workbook that opens "Exception from HRESULT: 0x800A03EC" I am not sure what this could mean.

I am hoping someone can help as this would save me a bit of time

Thanks