Hoping someone can help me to solve my dilemma.

My spreadsheet has two worksheets. One worksheet has a list of numeric
values running vertically, and I am trying to transplant them onto the master
worksheet running horizontally.

eg on the secondary worksheet A1=5, A2=6, A3=8 etc
on the master sheet, A1 ='secondaryworksheet'A1 and B1
='secondaryworksheet'A2 etc

The problem comes when I try to autofill across on the master spreadsheet.
Excel does not seem to recognise the sequence (I think it may be because of
the horizontal/vertical factor). I have tried to use absolute reference to
lock the column letter, but the numbers still do not go up in sequence.

Due to the size of the spreadsheet (5mb so far - so a lot of data) it is not
practical to manually fix all of the formulae. Does any have a suggestion
that might help?

Thanks