autopopulating several sheets from 1 sheet with drop down list...

I am trying to input data on a PO sheet then have it send the entered information to the correct sheets inside the workbook.

Example:

Date PO # description Vendor Amount category



after information is entered in the above slots you will click on the category column and from a drop down list choose which page you want it to go to. your drop down list will consist of Reimbursable Consumable, Non-Reimbursable Consumable, Reimbursable Equipment, Non-ReImbursable Equipment, and so forth and so on. I am wanting this so I can have a total PO page which has all the POs for the job then have the other sheets be populated from the above information and have a running tally of each at the bottom... I can do the summing of the columns but i need it to be able to grab it from 1 input page to keep from having to reenter on several different sheets.

So if you input your po information then click reimbursable consumable in the drop down box it populates the next available line on the reimbursable sheet.

Thanks in advance for any insight or help.

Example file attached.

After opening you will see the master po log this page will be where you enter the information. I have entered 2 examples. What i am trying to do is input the information on the master log and have it move everything to the appropriate page after one a selection is made with the drop down list in the category column. So that you only have to enter the information 1 time in a workbook and have it populate the proper pages, so that you can keep up with expenses on each category separate from the total job cost on the master po log.

After banging my head against the concrete wall... I have since figured out that instead of writing a bunch of code, that a pivot table on each one of my tabs from the master PO log will give me the same results with a lot less chance for error. I appreciate anyone out there that is trying to figure this out. as soon as I can figure out how to i will mark this post as solved.....


Chris