Select data from different worksheets

I'm using two combo boxes to select data.
On sheet1 I have data that refers to data on sheet2, sheet 3 and sheet4.
I need the combo 2 to be actualized with data on sheets 2, 3 and 4.

Ex.
In combo 1 I select: BMW, Ferrari, Toyota.

I need combo 2 actualized with info in sheet 2: BMW320, BMW330, etc. In case i've selectes BMW on combo 1.
That means tha sheet2 refers to BMW, Sheet3 to ferrari, and 4 to toyota.

Thanks a lot.

Re: Select data from different worksheets

Thanks a lot! that was exactly what I needed.