Ive melted my brain.

I know it can be done but I'm just not getting the Macro right.

Problem: I have the main worksheet with all the data. I want to be able to type a number in as a ID and have it transfer the data from worksheet 1 to worksheet 2...

Help..