How to compare today's date to a cell on VBA?

Hi,

I'm trying to create a macro which will:
-Open on the first sheet
-Get today's date
-Compare today's date to a certain cell in the sheet
-If today's date is bigger (=the date on the cell has passed) - it'll move to the next sheet and so on to the next sheets.

I thought you might have some suggestions, anyone?

Thanks,

Sivan.