To merge tables from different sheets or even different Google Sheets documents, use the IMPORTRANGE function to import the data into one central sheet first. This function allows you to specify the spreadsheet URL and the range you want to import. Once the data is in one sheet, you can then manually arrange or merge the tables as required.