entering a monthly changing work book name into a macro

ok guys and girls i have a workbook that is doing a copy and paste between 2 workbooks.

the trouble i am having is every month workbook a changes to be the name of the current month and year workbook b never changes.
so when a change in month happens the macro stops working due to new workbook name.

how could i have the macro reed the name of the work book and input that name into the necessary locations withing the macro.

i have looked across the internet and found no solution.

sorry this is a small idea of what i have at the mo

Workbooks.Open Filename:="C:\Users\Emily\Documents\Covers List.xls"
ActiveWindow.WindowState = xlNormal
Windows("Book1").Activate
Selection.Copy
Windows("Covers List.xls").Activate
ActiveWindow.SmallScroll Down:=24
Range("B35").Select
ActiveSheet.Paste
Windows("Book1").Activate

so book 1 changes monthly so would normally look like 01 jan 2014.xls and so on and cover list never changes.

how can i get the macro to get the book1 from the file name?

i believe i have stumbled across an answer but will not know until monday so any suggestions will great.