Replicate actions on multiple tabs

[Ronni f]

Hi,
I want to create an excel spreadsheet that has a main tab (ADMIN) with information on vendors - name, email address etc.
I then want three or four additional tabs that replicates the first ?? rows and ?? columns of the main source tab with this vendor information. They will then have different columns and headers depending on the tab.
If any row is added or removed from the main tab - this will be replicated to the other tabs

 

[Ronni f]

Hi. I wondered if anyone had managed ot look at this and could offer some advice. Thanks in advance. Ronni