Join all spreadsheets into one

[Manolocs]

Hello I am on MAC right now, I have 51 spreadsheets with 50 rows and about 25 columns each one, I tried to consolidate but there are many errors when there is a blank column, cell or row.
Is there a way to just copy in sequence the lines data from A1 to Z50 from all spreadsheets to one?
Any help is more than welcome.

 

[arthurbr]

Perhaps try this add-in

 

[Manolocs]

Perhaps try this add-in

I will try thanks arthurbr

 

[arthurbr]

Most welcome