Refresh links from another excel files

[Mansi_gnw]

My excel file obtains data from 3 different excel, I wish to create a workflow where data in each cell gets extracted from each of these files to specific excel cell (output file). I refresh these 3 links every month, so wanted to automate it.

[stataltgee]

@Mansi_gnw  please share some data file to get better clarity.

[Mansi_gnw]

The Screenshot from belongs to the file which , is further updated from 3 other input files.

[julioherrera]

Hello, my name is Julio Herrera. To automate the process of extracting data from three different Excel files into a specific output file and refreshing the links monthly, you can create a workflow using Excel's Power Query or VBA.

Power Query:

Use Power Query to connect to the three source Excel files.
Load the required data into the output Excel file, specifying the cells or ranges.
Set the queries to refresh automatically when you open the output file or schedule a refresh.

VBA Script:

Write a VBA script to copy data from the source files to the designated cells in the output file.
Add a macro to refresh data from the source files whenever needed.
Schedule the VBA macro to run monthly using Task Scheduler or manually trigger it.

This setup will automate the data extraction and update process efficiently.