Excel facing a problem with automation

Hi everyone,

I am currently facing a problem with automation of Ms. excel for my work and would highly appreciate any kind of help in this case.

I on a daily basis import data from internet on my excel sheet. The data is refreshed every day automatically. Now i want to copy paste last day's data on a separate excel sheet each day.

For instance i don't visit the excel file for three days all the information that would be imported should be stored on a separate excel sheets each day for 3 days..

I have no ideas of macros. If someone can help please.