How to plug data from 1 worksheet to another - not just linking 1 by 1

Is there anyway to do this in Excel?

I want to take some of the data I've entered on sheet 1 into sheet 2.

Sheet 1 is a list a data like this: (the dashes are only so it's not all mushed together on this, there are 3 columns)

Name-------------------------Pos #------------------------------SSN
1 Smith, John ----- 351-200-9990-901 --------------- 111-11-1111
2 Johnson, Bob ----351-200-9990-901---------------- 222-22-2222
3 Taylor, Emily-----351-200-9990-901-----------------333-33-3333
4 Dennis, Ashlie----351-200-9990-901-----------------444-44-4444

I want these to be plugged into sheet 2 (which has been set up into a form we need it in). but I also want to know if I can have it on multiple sheets without having to do it one by one. so all of #1's info is on his own sheet set up like sheet 2 and then #2's info is on his own sheet etc.


Sheet 2 is like this (but way more complicated, it is a timecard where we track various information, this is just the part that I want automatically filled in so we don't have to type over 3000 employees names, positions and ssns):

POSITION NO.: 351-200-9990-901
NAME: Smith, John
SSN: 111-11-1111

Is there anyway to have the info sheet 1 plugged into their own sheet automatically? I want to have say 25 sheets down on the bottom of the workbook and each one to match up with the designated rows/columns in sheet 1. is there a way to have it just automatically create another sheet down on the bottom if I add a new employee?

Your help is GREATLY appreciated.

Hi
How you have set up sheet2 is not indicated anywhere. To start with, insert data into sheet1 and try the macro in the attached zip file.
Ravi

Here is a sample of what I'm talking about. I can see what you've done so far is what I need, I just need to see if it can go into the boxes on the sheet 2 and still keep the layout of what we already have. Is that possible?

thank you sooooo much!!!