update sheets

Copper Contributor

Hello,
I want to make one excel file with 5 sheets that each sheet is from different file so when you change one file its changing the correct sheet in my file. Do you know how to do it ?

1 Reply
Data > Get Data > From Workbook
Select the Excel file and then select the sheet you want to connect. Click 'Load'
To update the data click Data>Refresh All

This is a bit of an advanced function in Excel, I suggest you read up or watch videos on how to use 'Power Query' in Excel