Hi CS319 and welcome to the forum,

I'd suggest you learn about Dynamic Named Ranges. See:
http://www.ozgrid.com/Excel/DynamicRanges.htm