2-way mirror of multiple cells across multiple worksheets

[buidiena3]

I'm something of a novice when it comes to advanced manipulation of excel, and definitely a newbie to forums....looking for some help.

I have a workbook with the first sheet as a 'Master Sheet' and several other sheets as subsidiaries, containing various configurations of the data on the Master sheet by filtering certain columns.
There are a couple of simple formulae in play, and some conditional formatting.

I want to be able to edit and/or add to/remove from the 'master sheet' and the changes to be mirrored across all sheets in the work book. And vice versa - edit one of the subsidiary sheets and those changes are mirrored across the rest of the workbook, including the 'Master sheet'.

I have been able to successfully get cells in the subsidiary sheets to mirror the 'master sheet' using simple "=Sheet1!A1" formulae, etc. but this obviously only works one way!

I have seen various people talk about VBA solutions to this sort of problem but I don't have the working knowledge to understand these solution, let alone adapt them for my use.

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.