copy data from one sheet into another on a weekly basis

I want to copy weekly updated data from one excel sheet into another historical data sheet on excel automatically every week 

and visualize it using power bi