You could put the sheetnames in A2:Axxx
and the addresses in B1:E1

Then put this in B:
=INDIRECT("'"&$A2&"'!"&B$1)
And drag across and down.

osaka78 wrote:

i have data in Sheet 1 under cell A1, B10, C5,D7
Sheet 2 under cell A1,B10,C5,D7
Sheet 3 under cell A1,B10,C5,D7
i want to combine the the data in the above 3 sheet in Sheet 4
Sheet A B C D
Sheet1 A1 B10 C5 D7
Sheet2 A1 B10 C5 D7 ..ect

--

Dave Peterson