VBA to Move and Link Data to other sheets

I am very, VERY new to code and need some help. First time posting so here goes nothing...

I am trying to create a spreadsheet with a master inventory price list that automatically moves and updates prices as they are changed or added in the master price list. I am also looking to have sheets created based on the location. I am in need of a code to do the following:
-1.Create worksheets based on the "location" spreadsheet in the workbook using the "template". As new locations come about, it should be able to add new if another is added to the list (as well as be removed from the list if one is deleted)
-2.As items are added into the "master" sheet, depending on what location that has been selected (columns "G" - "M"), that item information is posted to the corresponding location sheet. Item Name (column A), Unit Size (column D) and Unit Price (Column F) goes into the proper columns on the corresponding sheet created.
-3.As item prices are changed the are automatically updated throughout the corresponding spreadsheets.
-4.As items are deleted, they are removed from corresponding spreadsheets.

Well I think that is it... I am hoping that I am coming across clearly. If anyone would help it would be greatly appreciated. I have attached my starter sheet, although no code and not much, it will help in deciphering what I am trying to accomplish.