An introductions into dynamic ranges, creating vertical, horizontal dynamic ranges. Excel tutorial and File here: https://www.thesmallman.com/trapping-dynamic-ranges
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.