Help With VLookup Formula - Table Array

I am currently using the following formula:

=VLOOKUP($A$3, Sheet1!A:B, 2, 0)
=VLOOKUP($A$3, Sheet1!C:D, 2, 0)
=VLOOKUP($A$3, Sheet1!E:F, 2, 0)

The problem is I am trying to get the table Array portion (A:B , C:D , E:F etc.) to auto fill when I drag it across and it will but not correctly anyone have any ideas on autofilling with the pattern that I need?

Currently it would auto fill with D:E , F:G, H:I G:H I:J

Any help is much appreciated.