VBA copy/insert with closed workbook

[tf2722]

I have the attached #3 Inventory Sheet designed to track inventory. I've coded the add inventory button to copy relevant information and add it to the section below but need to now copy that row and insert into a master inventory file where multiple people are dumping data from identical sheets to this one. Thoughts?