Howdy and thank you in advance...

I have a data page that lists the name of individuals under a region Prior YTD, current YTD. The names of the regions can change occassionally and not all are entered in the same format

E.g.

Region
NORTH.PRIOR YTD
NORTH.YTD
MR SMITHS.PRIOR YTD
MR SMITHS.YTD

What I need to know is this.
HOW do I search the DATA page to find each of the "North" entries (up to four of them, usually one beneath the other on the "Data" sheet) and copy the name AS IT APPEARS on the Data sheet to the named "North" sheet?

Currently I have two columns one with the Region and one with the name of the company that goes with that particular region.