Johnnyz,

Have a look at dynamic named ranges. here's a couple links to get you started:
http://support.microsoft.com/kb/830287
http://www.contextures.com/xlNames01.html