Hi Vivek:

This is just an example. Say we want to create a summary table of many
sheets and we desire to create a column in which we have:

B9 from Sheet1
B9 from Sheet2
B9 from Sheet3
..
..
..

We can make this table by entering:

=INDIRECT("Sheet" & ROWS($A$1:A1) & "!B9") somewhere on the summary sheet
and copying down.
--
Gary''s Student - gsnu200751


"VIVEKMANE" wrote:

Dear All,
I am prepairing master sheet based on 14 sheets. I need to copy
data from every sheet and paste it into the master sheet. So, is there any
shortcut or formula for the same to paste all the 14 sheets to a single
master sheet.

Regards,
Vivek Mane
mailto :
+919223350659