copy cells to a new sheet based on what is put in another sheet

[nfisher1510]

I have a workbook that has two sheets. Sheet 1 is all inventory. Sheet 2 is for the inventory in Sheet 1 that will be shipped to a specific location such as "Aspen Hospital".
If "Aspen Hospital is typed into Sheet 1, I would like all information from that line copied into sheet 2. What formula should I use? I have seen the VLOOKUP and the MATCH, but I am still not getting what I want.

Example:
B3 through D42 is all the inventory information.

E3 through E42 is where it is to be shipped.

If Aspen Hospital is typed into E3 through E42 in sheet 1 I want it plus it's corresponding cells to be copied into sheet 2.

I figured the formula would go into sheet 2, but and the look up would happen when Aspen Hospital was inserted in the cells in Sheet 1. But I cant get the corresponding info to copy over.

Thanks and let me know if more info is needed.

 

[BrianJN1]

It would be good to see an actual example (not actual data of course) of where you are at this point.

 

[nfisher1510]

It would be good to see an actual example (not actual data of course) of where you are at this point.

I used the IF formula in sheet 2 and got it to work.
Thanks