Hi Ken,

Thank you for your suggestion. I will try it and let you know regarding the
result.

Much obliged

Regards

Albert

"Ken Johnson" wrote:

Hi Albert,
One way of achieving the same effect is to use INDIRECT and ROW
functions. For example, say you want a column on Sheet1 to show each
sheet's A1 value. This can be achieved by placing the following formula
into any row 1 cell (other than column A) then filling down so that
the number of cells with the copied formula equals the number of
worksheets:

=INDIRECT("Sheet" & ROW() & "!A1")

Ken Johnson