Macro to run several pivot tables on different sheets from source data

Hello,

I have been frequently posting questions to Excel General forum. And found quick answers from here

Now I have a macro question which may sound simple to you excel geniuses. I'm a first time macro user


I have a master file with massive amounts of data. I need to do pivot tables of different forms on individual sheets with names for each sheets. The sales data should be the top 25 in an ascending order.

I have to do this process first day of every week. I will need to update the Master file first day of every week to too by merely copy and pasting from another database.

I have attached a file which migh help you to get a better understanding. If you could give me a step by step procedure.

This would really save my life !!