Drop down list to provide me with two additional drop down lists selections....

Thanks for the help in advance

I received some help awhile back on my first problem. This problem was that once I selected a "Tool Type" from a drop down list, it would provide me with the list of "Tools" in the next cell. Once I select one of those tools it would fill in a few other areas with the proper information.

I know to do this I had to have the "Tool_Type" name and the table that the "Tools" were located named the same.

Is there a way that by selecting a certain "Tool_Type" that it will provide me with a drop down list from another table, outside of the "Tools" table? Say I wanted a table that contained "Tool_Holders" that were only used for certain tool types.

Any help would be great!

Alright that explanation is confusing as all heck. to break it down

My file has a drop down list of "Tool_Types"
I can select a tool type, the next cell below it =Indirect(cell#)
This cell references the tool type to find a tool number, then I select a tool number it fills in about 8 cells below it with the right information.
Below those cells is the cell I referring to. I need this cell to pull from another table, the table is decided by the tool type. How do I do this. I had help with the indirect part the first go around. The way it seems to work is that the cell must have an identical name to the type.