VBA for variable lookup from data validation list

Hi All,
I am after VBA code that will basically lookup a variable range of values in reference to 3 separate data validation lists. The tricky part is that I want the results of each lookup under each other the with no row gaps regardless of how many results the reference gives. Confused? I hope this makes sense to someone because this will be a great help if it can be done! Please see attached spreadsheet.

As an example I have populated the lists with:
Product Range 1
Product Range 2
Product Range 3

The lookup values for these groups found on the ‘Ranges’ sheet are:
12151632
12071779 12071882
12097730 12071890

So the end result on the 'Promo' sheet from A3 down when these product ranges are selected in the 3 lists will be the below sequence:
12151632
12071779
12071882
12097730
12071890

Appreciate any assistance.

Hi Ravenous,

I hope that this procedure will do the job:

Please Login or Register  to view this content.

my thoughts

Please Login or Register  to view this content.

Nice work stnkynts!

Thanks fellas! How do I make it run automatically everytime the selection changes?

Do you mean this?

Please Login or Register  to view this content.

Or does it need to copy over based on all 3 values? This one only copies over the changed cells lookup values.

Sorry i'm new to this and not sure how to make this code run but I could with the first one. What is the difference between a sub and a private sub?

Thanks

The Sub Worksheet_Change procedure should be put in the "Thisworkbook" module.

Close, it would be put under the Sheet1 (Promo).

Oh, my mistake!

Sorted! Thanks to you both for your help.