Make List Of Parts For A List Of Products (Excel)

General information for the business: we sell parts for mobile phones tablets and consoles Industry: Technology Data to include: Product Image, Title, Model, Web Link Extra notes: I have a list of models for iPhone, iPad, Samsung Galaxy & some Game Consoles. i need a comprehensive list of every single part that is inside these devices such as screws, glue adhesive strips, screens, speakers, brackets EVERY PART THAT IS CONTAINED IN THE DEVICE. on the excel i want it to include information such as product image, title, model, and web link to example online. Attached is complete model list and the excel template to fill in. please confirm you understand what i am after.