creating a report from data in a another sheet

Hi all

I wonder if anyone can help me. I have one sheet (sheet 2) in my excel workbook containing raw data. in this sheet I have put an identifier column and next to every row of data i have keyed in the appropriate identifier for the data in that row.

Now I want to generate a report on the other sheet in a certian format. the format should be as follow: section A of the report to contain data from the matching identifier on sheet 2.

Now is there a forumla in excel that can select the data i need it to report on or can it only be done in VB???

Please please help.