Hi,

I have a workbook with a few sheets, lets say for arguments sake sheet 1,2,3,4,5.

I have another sheet called "Data" in which I have a list of names and numbers in two columns like this:

Name - Sheet
James - 1
Alex - 2
Martin - 3

My Question is how do I get just the names with an sheet ID of 1 onto sheet 1 and so on.

Thanks,
John