update sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2454619%22%20slang%3D%22en-US%22%3Eupdate%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2454619%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20want%20to%20make%20one%20excel%20file%20with%205%20sheets%20that%20each%20sheet%20is%20from%20different%20file%20so%20when%20you%20change%20one%20file%20its%20changing%20the%20correct%20sheet%20in%20my%20file.%20Do%20you%20know%20how%20to%20do%20it%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2454619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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