List Data Validation Fails for Dynamic Ranges

Hey There!
I'm working on trying to maintain an inventory management sheet where i basically enter all the spare parts issued to vehicles.
Now there are more than 700 parts dat form the components of a vehicle, so i decided to split this list into 12 spare groups(Gear, Engine, Body, Axle, etc etc..) and then based on wotever spare group being selected my sheet wud pull dat specific spare group list.
Since i've worked with indirect function before i thought this was a piece of cake!

However when i actually sat working on getting my sheet together i realised its not gonna be dat easy!
Basically my spare group lists are a work in progress and so new items would/may be added to these lists as we start working on this sheet. So i decided to make them dynamic by using the offset function.

But list validation fails when i use Indirect function on dynamic ranges!

Is there a way to sort this issue out?

Thanks as always for the wonderful help and support!

Regards

Mohit

There is a section at the bottom of this page that instructs you on this problem:

http://www.contextures.com/xldataval02.html

Section entitled: Using Dynamic Lists