Excel Combine Multiple Sheets > One Master Sheet

Hello I have one file with 598 sheets, yes it is a lot! I need to consolidate all the data into one master sheet so i can import into Google Sheets. Columns A,B,C,D 4 Columns Total 598 Sheets Must avoid any empty rows. Had no issue on a different file and imported the excel to google sheet, and this was working for me in Google Sheets with following Formula: =query({'Table 10'!A:D;'Table 11'!A:D;'Table 12'!A:D;},"Select * where Col1 is not null") However Google Sheets was unable to load this particular file due to too many worksheets.. so must find some way to do it in Excel, and I do not know how to do it on MacBook. Thanks.