My macro button is on sheet1.

On sheet2 is an ever growing database of information. There are 5 different
column values and the information is grouped by row.

(not sure that explains it well)

I want the macro button on sheet1 to initiate a search of the database on
sheet2.

I want it to search all the contents of column A (excluding A1)
For every cell that matches the search I want to select that row and copy
the 5 column values for that row onto sheet1.

Haven't been able to figure this one out.

Any help would be greatly appreciated.

Thank you!
Ryan