I have been asked to populate cells in a spreadsheet (Sheet1) with
data from another spreadsheet (Sheet2). Both sheets contain monthly
data. Sheet 1 has the monthly data running down the columns i.e.
Jan=Row1, Feb=Row2 etc. Sheet2 has the monthly data running across
the columns i.e. Jan=ColA, Feb=ColB etc.

The problem is as follows: When I link the first cell on Sheet 1 and
then try to drag the formula down to the other months, the formula
does not update as I want it to i.e. linking to the next cell
horizontally in Sheet 2. Obviously it links to the next cell
vertically in Sheet2.

Is there an operator that I can insert into the formula, so that when
I drag it vertically in Sheet1, it knows that I want data from the
next cell horizontally in Sheet2?

If there were only a few cells involved I'd just do it manually, but
there are thousands.