Selecting rows from various sheets

S

shav

Hi all,
I have several sheets with a few columns in each. One colum
in each sheet has a unique value. Most of these unique values are th
same in each sheet but not all. Is there any way that I can set up
new sheet that will have the unique value in column 1 and th
corresponding column values frommeach sheet beside it. For example
Sheet 1
aa 1 1 1
bb 2 2 2
cc 3 3 3

Sheet 2
aa 4 4
cc 5 5

Result
aa 1 1 1 4 4
bb 2 2 2
cc 3 3 3 5 5

Thanks alot,
Sha
 
Top