Dynamic Data Validation from another sheet

Hi,

Is it possible to have a dynamic data validation drop down list in Sheet1 that references a dynamic range in sheet 2?

I couldnt figure it out. I know I can have a dynamic drop down list if the data validation cell and the dynamic range are in the same sheet because Ive tried it and it works. I did this by selecting my range and making it a table. I am using excel 2007.

Thank you.