Return muliple values using Vlookup

Hello,
I know there have been posts to use Index function to search for a particular number or text in a database and return their respective row elements, but i was unabale to execute it.
So here s the problem:
In the excel WORKBOOK named 'UnitsperHr Database'. I have 5 columns namely CC,Job No., description, Budget.
In my other excel WORKBOOK named 'Labor Productivities-COST CODE WISE-MK', I want to return all possible CC with their respective row elements.
So say CC -730 in the first sheet, i want to return all possible 730's from workbook1 to workbook2 in the WORKSHEET named 730. Then there will be different Sheets for diffirent CC.
PS 'CC' Means Cost code. I want different sheets for different cost codes based on the data that i will dump in workbook1
Thanks for the help!!!

Thank you ben, Thats what i am currently doing. But i want diferent cost codes in different worksheets so that my boss can analyze each cost code. What is the best way to do that?

Try this UnitsperHr Database.xlsm

Jason, thats exactly what i wanted except that, whenever i add more data to my first excel workbook, i want this workbook to update as well. I dont even mind having one work book, like the one above in this post, such that whenever i add data to my master worksheet, all other cost codes worksheet update itself.
Can it be done?
Thanks a ton!!!

That was just a quick test to see if it was suitable, the code was some that I use in one of my own workbooks with a few minor tweaks to match your data.

As you're happy with that I'll make the other changes that it needs then post a revised version once I've got it right, that might not be until morning though, it's getting late this side of the atlantic lol.

That's alright. Also will there be a way by which all the columns will be tabled or will i have to do it manually? Also I want to add a scatter chart for each. Can i do it for one sheet and copy on the others or will i have to do it for all the other sheets.
But thank you so much. I know it is late back there.

Not tried doing this with tables or charts so that will be something new to have a go at.

Do you update your master sheet slowhand (typing in 1 cell at a time), or copy and paste several rows from another source?

Just having a few quick thoughts on how to make it work, would there be any problem with the code adding an extra column to the master sheet to keep track of the records?

Well, it depends.. I do both. No there would be no problem adding an extra column to Keep track of changes. Also how can i use the code to create more excel workbooks such as this one so because i realise i can do away with a lot of data reentering/sorting with this kind ofcode.for eg; i get frieght calls for different constructionsites, and i want to enter all the calls in one master sheet and the correponding data such as date, qnty, remarks can automatically get parked in the respective excel worksheet categorized by construction site.

Thank you so much.,

Hey Jason,
Have a look at the tab'730' which has a graph, the cells are tabled and there is avg of the data. Thats the idea to do for every cost code. Shortcuts appreciated.

Thanks

See what you think of this.

You will need to click the button once to process the data that is already on the sheet, after that it will be processed automatically as you enter it.

Copy of UnitsperHr Database.xlsm

I've added something else that I use when I have a workbook with a lot of sheets, try double clicking, any cell, any sheet

Jason,
Perfect, thank you so much. I know whom to contact for all my excel doubts and adventures.