I am working with a cost spreadsheet.

I need to be able to pull a group of cells (part numbers, description, price for several parts) into Sheet 1 from sheet 3 by entering a "group number" in one cell on sheet 1.



This will pull each series of parts in based on the group number in the row above the group of cells.

How can I do this?

I.E.

I enter 1/4" in cell Sheet 1, A1

this brings into sheet 1

all 1/4" bolt sizes and part numbers, prices
all 1/4" nuts, part numbers, prices
all 1/4" washers, part numbers, prices
etc.

I want to place the group starting in cell Sheet 1, B2


Thank you