How to - dependant dropdown lists from a dynamic set of data

Hi

This is my first post on the forum. I have tried to search for solutions over here as well as other websites, but haven't found any. So, i guess i can ask the excel experts here to shed some light into the problem.

I have a list of products with various manufacturers. This list is continually edited - rows are added and removed.. Here's a picture

\1
image upload

Now, i need to create a data validation system to create BOQs. So, i need to have a drop down menu for

1) manufacturer ( say, column H )
2) product ( column I )

\1
image hosting

Now, depending upon column H & I, columns J and K ( item description and Price ) should fill up automatically.

The catch is this - i want this to be automated. The original sheet, containing all the details will be updated on a regular basis. And i dont want to be changing any code or data validation lists

I have acheived the above ( only columns H and I - i pasted in columns J and K manually ) using indirect data validation ( pic below ), but i don't know how to get things done in an automatic fashion.

\1
image upload

Can this be performed from within MS Excel. I do have MS Access - is it better fit for this job?. I have no clue. I'm not very much aware of the intricate workings of excel - pretty much a newbie, but learning. Any advise in any direction would be of great help Please, lend me a helping hand