Can anyone help me please ?

I have a spreadsheet called Data.xls and on sheet1 is a table of figures: A10 to I50 where column A contains a code and columns B to I relevant data.

I want to be able to take relevant data from Data.xls!sheet2 into another spreadsheet called Analysis.xls - sheet1.

What data is brought across is based on the code in Analysis.xls !sheet2 cell C6 matching the codes in Column A of Data.xls !sheet1.
Ie: if the code is Group1 then it will return all the data in Data.xls where Group1 appears as a code in column A.

Is this possible ? Thanks for any advice

Amy xx