I am trying to link multiple workbooks together

Hi, i'm somewhat new at excel, i know the basics, and i've tried a few macro codes. I am trying to have multiple workbooks linked together so that when i enter a new row of information in my master inventory list, it is automatically entered into the other workbooks, in the very next row that is empty (at the bottom of the list). Each workbook has the same layout (same column headings) i just don't need every item in my inventory list to be on every other workbok (ex. Sold list,bought list,) is this possible?

I apologize, i believe the word i should have used was sync...
Thanks,
denise

Also, i'm not advanced enough to write a code, i can only copy and paste a code to my wk/bk and edit it to make it work for my book.. I apologize in advance, i'll be having a lot more questions as i set up my business

Ok, i tried to attach a preview for you. The invt list has more items than the sold list, and when i add a new item to the invt list, i'd like for it to automatically be entered into the next line on the sold list (just for ex.)

I'm not sure how to do that.. And i believe my [img] is turned off. Do i need to turn that on in order to send an attachment?