I am struggling with an excel feature regarding creating a Source and Destination workbook.

My Source data comes from the web. So I download it, create few new columns and functions and use it to make a dashboard on Power BI. This dashboards needs to be updated as and when data on my source changes.

Since I have to make few changes to the Source data before making dashboards on Power BI, I cannot directly link the data for automatic updates.

The idea here is to create a Destination excel sheet with all necessary columns to connect on Power BI. And then download the Source file and create a link. In this way I should be able to download new Source File every week which will update my Destination file and finally update my dashboards!!

How can I make this happen? I am not excel expert and really need help!!

PS I am using office 365, Excel version 2102