? Auto duplicate row contents from 1 sheet to 2nd sheet if column contains set words

Hi all

Is there a way (using functions/formulas) to have Excel automatically duplicate the contents of a row on one sheet onto another sheet within the same workbook if text in one column of the first sheet contains a certain word? And if so, how could this be achieved?

I have attached an example workbook to help explain what I'm trying to achieve.

What I want to end up with is when I type text in any row of the Master sheet, I would like the entire contents of each row to automatically be repeated on the worksheet of the same name (as per column O). For example row 5's contents from the Master sheet would duplicate into the sheet named Accommodation. In addition, should the details ever change in the Master, this would need to be reflected in the individual sheets also. My only concern is that I'd like the individual sheets to fill from the top rather than match the exact row number position from the Master, ie row 5's contents to be placed into row 2 of the Accommodation sheet seeing as it's the first occurrence, and row 6's would go into row 3 etc.

I hope that all makes sense, please let me know if not.

I'd be hugely grateful for any suggestions & help. Thanks heaps.

Sue

Please have a look at the attached.

I've added some code to the Master tab in the VBA editor (ALT F11) which will fire every time a change is made to the master sheet.

I've chosen to regenerate the appropriate slave sheets entirely when a new entry is made to avoid complexity if a category is changed on the master sheet.

I've also added validation to column O on the master sheet so that a match can be guaranteed between the entry and the slave sheet name.