Learn how to combine multiple tabs to one master tab when you have random column order using Apps Script in Google Sheets.
Script: https://www.chicagocomputerclasses.com/google-sheets-apps-script-combine-multiple-tabs-to-a-master-tab-when-column-positions-dont-match/