The steps I need to do are as follows
Book1 Sheet1!A2-A49 paste into Book2 Data!H2-H49
Book1 Sheet2!A2-A49 paste into Book2 Data!H98-H145
Book1 Sheet3!A2-A49 paste into Book2 Data!H194-H241
Book1 Sheet4!A2-A49 paste into Book2 Data!H290-H337
Book1 Sheet5!A2-A49 paste into Book2 Data!H386-H433
Then save and close - preferably with title of Book1 and today's date (this process will always be a Saturday) as the file name.

Then:
Almost the entire same process again but instead of cells A2-A49, it'll be B2-B49 but they get pasted into the same cells so the 'save and close' part is important otherwise I'm just going to keep overwriting my previous pasted info. Also I want the date to be Sunday's date.

The process continues to repeat itself for columns A through G, and the file names will go from Saturday to Friday's date.

Does anyone know if this is possible? I have the process of doing it piece by piece but what I don't have automated is the Save & Close, naming the file and moving onto copying the next set of cells from Book 1.

I hope this isn't too confusing. I've been on this process for weeks now and I'm pretty much stuck and would like to get this process complete if this is actually a possibility with Excel 2010