Is there a quick and easy way to get a range that you have entered into a
formula or feature to expand automatically.

For example, if I am creating database functions, I want my formulae to
update automatically to include new entries I add to my data list, or a pivot
table to update with new entries that are added to the list.

Any help would be appreciated.
--
Thanks,
Rob E.