Populate data from sheets to master

Hi all.

Apologies as this is probably a very basic request, but I'm stuck.

I have one spreadsheet. This contains four sheets, Audit, iPhone, Laptop, iPad. I'm trying to consolidate the iPhone/laptop/ipad sheets with the main Audit sheet. If there is an entry for 'John Smith' in Audit, check the other sheets, and where there is a match, i'e' John Smith is also listed in the iPad sheet, auto populate the Audit sheet under the column 'ipad' with the exact data i.e. iPad Air etc.

Document attached. I hope I've made sense.

Thanks in advance

Like this?