VBA - Date issue

[JBBryan]

I am new to VBA and i have been able to fumble along up until now. This is where i am stumped:

In Sheet 1 (C1) I have todays date. I need to copy data from Sheet 2 (AA2:AA75) and paste on Sheet 3 based on the date from Sheet 1 (C1) plus 1 day (Tomorrows date). Dates on Sheet 3 are located in (C1:AG1) data would be posted in rows (2-75)

The exact same procedure would need to be done for Sheet 4 copied/pasted into Sheet 5, and Sheet 6 copied/pasted into Sheet 7. ALL rows and columns on these sheets are the same as Sheets 2&3.

Any help i can get is greatly appreciated.