vlookup formula changing lookup range automatically

[i.beard]

As I copy and past my lookup formula down the page it is changing the lookup range which I think is what is giving me so many #N/A results.
My first Formula is
=IFERROR(VLOOKUP(A2,Coors2!A2:D3765,3,FALSE),IFERROR(VLOOKUP(A2,'AB2'!A2:C13944,3,FALSE),(VLOOKUP(A2,'WM2'!A2:C4843,3,FALSE))))

Then for instance at line 59 the formula is
=IFERROR(VLOOKUP(A59,Coors2!A59:D3822,3,FALSE),IFERROR(VLOOKUP(A59,'AB2'!A59:C14001,3,FALSE),(VLOOKUP(A59,'WM2'!A59:C4900,3,FALSE))))

Why is it doing this and is this in fact the problem?

[zbor]

You must lock range:

Coors2!$A$2:$D$3765

(in all vlookup ranges)

[i.beard]

That was it Thank you