Hi there,



So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I was told to start new.

What I'd like to do:

Have a raw data page where all the information for every client we get can go.
Drop down menues on the first column which will help separate the data into different sheets for easier mailmerge purposes.
a formula, that will take the information entered in a row, and send it to the correct sheet when the specific drop down choice has been made.

For example:

Raw data page

Code | Address | Name |

1 | 122 Avenue | Bob | <-- This data with code 1 will then be sent to page 1.
2 | 156 street | Joe | <-- This data with code 2 will then be sent to page 2.

and so on...

This way, rather than having 5 or 10 separate workbooks I can then have all the information entered on 1 raw data sheet and then separated into the specific sheets for and if I have to search for a specific name I don't have to spend hours going through previous workbooks to find it.

If this is possible please let me know.

**Side note, I have already found how to make the drop down menues, I just don't know where to go from here.