Make the named range dynamic

eg

=A1:offset(a1,counta(a:a)-1,0)

would give you all records in column A