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?