Automate a copy/pasting of a row of information based on a changing date

Hi everyone,

I'm trying to automate a copy/pasting of a row of information from one spreadsheet to another every day (and to realize the daily date changes).

Here's a typical walk-through example:

1. Open up \\Stats\2012\Jan\1.1_file.xlsx
2. Copy row 88 (this is static and doesn’t change)
3. Open up \\Totals\AnnualFile.xlsx
4. Click a the “Daily Sheet” tab
5. Paste the information into the corresponding Date row (such as “Sunday, January 01, 2012”)
6. Save file

I need it to do the logic on its own. I’m learning VBA as I go, but this one is over my head so far. Any help is appreciated!

Thank you!

-Mike

I battled with this all day...ugh. Any suggestions?