Creating+saving multiple charts from a single worksheet

Hi all,

I would be grateful for any help you could provide with this query.

Basically i have a lot of repetitive tasks to perform in work and need to speed them up so i can spend more time on interesting stuff.

I am attempting to record a macro from a single work book that creates and saves multiple work books containing graphs of the data and the relevant data from the original workbook.

I would also like to create hyper links for these graphs in another work book which contains all of the data graphed weekly.

The data is spread through out the workbook so simple dragging will not work. I must do this for the start of every week. So for example i would generate data for drip rates for 50 seperate samples for week one then graph them and save them in a folder under week one then hyper link to them from another work book and then do the same the next week from data generated that week.

I would truly love to automate this process.

Thanks