Forum Discussion
Betsy2125
Dec 03, 2018Copper Contributor
Combine spreadsheets into one
I have this code in Google Sheets which combines several spreadsheets, in the same workbook, into one master sheet. =QUERY({Sheet1!A2:C;Sheet2!A2:C;Sheet3!A2:C;Sheet4!A2:C;Sheet5!A2:C;Sheet6!A2:C;S...
JKPieterse
Dec 04, 2018Silver Contributor
PowerQuery is what you are looking for: https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/