Can I Auto populate cells based on value in another cell

Hi,

I need to fill several columns of flow requirements based on a pn entered into a cell.

What i need to happen is the pn cell gets filled, then the flow requirements fills in from data on a second sheet.
I have included the workbook i am using. It has sample data in it. The blue cells are the ones i need to have auto populated.
Sheet 2 has the data that would go into the cells.

Not sure how to proceed.