Macro to search multiple Documents and delete Rows.

Let me preface this with the fact that I truly do not understand creating a Macro, give me some HTML, PHP, or a few other things and I'm good but I have never even attempted to create a Macro. That being said...

So, I'm going crazy and I figured this might be a good place to get some help so here goes. I'm trying to create an Excel Macro that will pull a list of numbers, then search my spreadsheet and if any of the numbers are found delete the entire row. I have been doing this manually but it's extremely tedious and I have to search through multiple spreadsheets each day. Anyone here know enough about Excel and Macros to be able to help me out?

Oh yeah, I have cross posted this at tizag.com but this is more for web design than Excel help so I posted it here as well.
http://forums.tizag.com/showthread.php?t=9650