How to pull unique data from another sheet

Hi All, I require a stock Take Page, that I can print off to use a hard copy. I have provided the information that is entered in to the Summary and the information I require pulled through from the summary, that needs to be on the Stock Take sheet.

Ive attempted to use lookups but they wont lookup and pull through the data from multiple lines on a completely automated sheet.

Is there any formulas that will pull the information?