EXCEL V12LOOKUP

详细信息

I have a product range from which I make kits containing various products from the range but the kits all vary in contents.
I am seeking a skilled individual to create a bespoke Microsoft Excel workbook that will help serve as a Master Sheet, and separate working Microsoft Excel workbooks which are data connected to the Master Sheet.
Please see the clear requirements below:
1: I want a Master Sheet created that contains all the products complete with SKUs, and various levels of pricing i.e. A: List Price, B: Distributor Price, C: Training Price, D: Cost Price.
2: I then want to be able to simply create Kits on another Excel sheet by using the Master Sheet.
3: If I delete products from the Master Sheet it deletes the same product on all the other sheets. If I change a price on the Master Sheet it updates all prices.