How to transfer entries from a master data sheet to sub sheets?

You can do it with 3 basic formulae. Post an example workbook (anonomised), and I'll show you how.

Hope this helps.

Pete

Obviously I can not post an original file, so here is a dummy file which should do the trick as an example.

Okay, take a look at the attached file. I've inserted a new column A in the data sheet (Sheet1), and this format is also used on the subsidiary sheets - you will need to copy formulae on these subsidiary sheets down until you see hyphens in column A. I've also set up a small table on the ref_data sheet which lists the regions you have used, and I've also added a "None" category for those records where a region is not specified.

Let me know if you need any explanations as to how it all works. You can change the sheet names to whatever you like, as the formulae are not dependent on them.

Hope this helps.

Pete

This was very helpful, I was able to use your concept in slightly adjusted way.

Thank you!