I have a worksheet with data setup that is referenced by several other
worksheets using the vlookup formula. The first worksheet would use the
formula: =vlookup("a",a2:j10,2,false). This then needs to be copied over
changing the column in the formula each time. ie:
=vlookup("a",a2:j10,3,false), =vlookup("a",a2:j10,4,false) etc.

Is there an easier way of doing other than manually?

The other problem I have is that the same formula is used again on other
worksheets referencing the same data only starting on a different column.
For example a2:j10 would change to b2:j10 and then c2:j10. It moves over one
column for each worksheet.

Any help will be appreciated.