Gathering information from multiple workbooks and sheets error

[Farley945]

Hi All,

I am coming up with the following errors on my workbooks, couldn't someone please take a look for me (Any help with shortening the code and making it easier would be much appreciated!)

The example Doc. is the master sheet which collates data from 210 different workbooks which are all laid out exactly the same.

The help I need is with:

column C & D - Entering the month the same as row 7.

The months data does work but I get Run-time error '1004': Unable to get the Vlookup property of the worksheetfunction class. I am unsure why I get this error because I thought the on errors would solve this. (I couldn't get the Iferror function to work properly.) IfError( 'can't find the month on the Current Year to look in the Previous Year.)

There is also an automation error which goes straight over my head. (Sorry.)

The formulas in 17 - 24 I cannot get to work in code.

Any help is appreciated and sorry if it seems like a lot, I tried but still a novice at macros, hopefully there is also enough information provided.

TIA