Duplicate a master list where all slave lists auto update when changes to master are made

I manage 69 people and maintain various details about them in one workbook across 5 worksheets. Each worksheet has identical data in the first 4 columns, employee number, name, position, department.

Due to the nature of the job people change departments on a regular basis and often it can be multiple people or I may bot hear about any changes that happen for 6 months or more. This is a huge administrative burden when I have to update all 5 worksheets manually.


What id like to achieve:

Use a single data set which is then duplicated into the first 4 columns of each worksheet so that when I update the master all of the slave lists update automatically.



What considerations to take:

Each row has data relating to that individual which I need to make sure follows any changes i.e move from row A1 to A2

Each worksheet is configured as a table with headers and uses a custom filter

Each table uses conditional formatting

All the tables are identical length A3:D4 - A72:D72



Is this possible?

Hi Bernie thanks for the rapid response.

I agree with your advice it would be easier to have all the data in one sheet but it relates to different aspects of information for example one holds driving license details another holds training course details.
I designed each one separate and then consolidated them so it is still a work in progress. Also the people who use this spreadsheet are not all very competent so my aim is to keep it as simple as possible in terms of layout.

My main reason for posting is that I cannot figure out what feature would help me achieve the goal. I will try you suggestion and come back ASAP