array formula

Try this.

HTH

Can I ask one more quick question in regards to your awesome, amazing SS? Do I have to have the number identifier cell in column A on worksheet 2 and 3 or would the Row command (or some derivitive work)

Just curious... I can easily hide that. This is fantastic. I just hope I can replicate it in the real final version!