VBA Formula; Automatically update multiple workbooks from MASTER

Hello,

I am trying to help a friend with his restaurants.

There is a MASTER list with all the food/drink items.
There are 7 locations.
Each location has its own workbook with their own specific food/drink items.
Each location has the VLOOKUP formula attached to the MASTER list so each location gets automatically updated once the MASTER list is updated.

Let's say, for example, I would like to delete a column from the MASTER list and have that column automatically get deleted in each individual locations workbook. How would that VBA formula look?

Thank you for any input.