delete row(s) based on cell value in different sheet

[MisterrMr]

I am looking to build or find a macro that will delete rows from one sheet dependent on the value of a selected cell in another sheet.
(Excel 2003)

i.e.: When on a cell (say A1) in sheet 1 and the macro is ran it will find any row in sheet 2 with the same value (in A column on sheet 2), and delete the row(s).

I hope this explains it well enough.

Thanks
Loren