Hi

I have an excel file with many worksheets. On the first sheets there
is a lot of data which will be used in cells in the other worksheets.
On the othersheets I have want to place formulas to get celldata from
the first worksheet. Lets say that I want to get the data from cell
C49 from the first worksheet, the formula would be =Sheet1!C49. But I
want to get the last number of the formula ( e.g. 49) from a cell on
the sheet where the formula is used. How should the formula look like?
For example on the second sheet I have a cell (A7) which has a number
( e.g. 47) and I want to place that number into the formula.
I tried =Sheet1!C&A7, but that gives me an error.

Can anyone help me? It looks very simple!

Regards