Following is my sample code:

Windows("sample_1205.xls").Activate
Range("A4:C20").Select
Selection.Copy
Windows("xxx_122005 worksheet.xls").Activate
Range("H4").Select
ActiveSheet.Paste
Range("H3").Select

this code activates the first file and copies a range of cells to the second
file where "xxx" is a 3 digit number that changes, depending on the value in
cell "A1" of "sheet 2" in the "xxx_122005 worksheet". This worksheet is
also where the macro is stored.
Is there a way to get the macro to read cell "a1" as part of the file name?