Dependent on a value, transfer info to specific worksheets

[Jacksendall09]

Hi,

First post - go easy!

I'm wanting to set up a spreadsheet holding master data and lots of information within the first tab. However instead of pasting the information to the relevant worksheet I need a formula for it to pick up the relevant data and then move it to the correct worksheet.

For example:

If I have the word P AC selected on the master sheet it takes the name and d.o.b from the master-sheet and inserts that information to the P AC worksheet.

There are 13 potential worksheets where the mastersheet could send the info to.

Thanks in advance.

Jack