group multiple data in different sheet
 

Hi guys,

Im currently using office 2000, i have the following problem, i need to
group different data array, one data array on each of my spreadsheet. i need
to group them as one so that i can search using INDEX AND MATCH on the 1st
sheet, on the group data array.

can that be done??
--
Thank you in advance

regards,
alibaba