https://quadexcel.com/wp/excel-vba-tutorial-98-combining-data-from-multiple-spreadsheets-using-ado/
Excel VBA Tutorial 98 - Combining Data from Multiple Spreadsheets using ADO