Self populate tables based on criteria of data in 'master' table

Hi,

This is my first question on the forum, I apologise if I'm not using the correct terminology or explaining myself properly - I'll do my best.

I work in Business Development, one of my duties is to prepare, submit and monitor the progress of tenders/proposals for new prospective clients

I have a 'master' table which lists each tender/proposal with some basic information on each row. One of the columns on the master table is labelled 'Stage' -This is a dropdown with options; 'PQQ', 'ITT', 'PRESENTATION'. I then have three other tables, all the same as the master table but labelled as; 'PQQ Stage' ITT Stage' and 'Presentation Stage'.

What I am trying to achieve is this; When I enter data onto the 'master' table, I want the other three tables ('PQQ Stage' ITT Stage' and 'Presentation Stage') to self populate depending on the criteria of the 'Stage' column. For example; any rows with PQQ entered into the 'Stage' column of the 'master' table to automatically copy into 'PQQ Stage' table..... any rows with ITT entered into the 'Stage' column of the 'master table' to automatically copy into 'ITT Stage' table.

The image below shows basically what I am trying to achieve. I've also attached the Excel spreadsheet for you guys to look at and edit if need be.

Example2.png

This is only a very basic spreadsheet with basic tables - I only made this for the purpose of demonstrating to yourselves exactly what it is I require.


If any of you guys can help me it would be much appreciated. Many thanks, Ross