Consolidate tables into a single spreadsheet

How can I create a single excel spreadsheet from 180 tables (all with the same format? Ray