Copying cells from 1 worksheet to another

W

WMO

I have 17 work sheets with the same column/row information repeating on
each sheet but each sheet is for a different customer. I want to bring
info from sheet 2 thru 17 to sheet 1.

Is there a way to write a formula so that I do not have to keep
re-typing the formula?

For instance, I want cell b2 on sheet 1 to be the text from cell b2 of
sheet 2 and cell c2 to be the text from cell b2 of sheet 3, etc.

Everything is text so there are no calculations, just bringing the text
to a sort of summary sheet.

Thanks, in advance for any help.
 
B

Bernard Liengme

On Sheet1 in cell B2 enter =INDIRECT("Sheet"&COLUMN()&"!"&"B"&ROW())
Copy across to column Q
Select B2:Q2 and copy down as far as needed
best wishes
 
Top