Do the 2nd part first.
This means that when you create the named range tbl, then add the following formula that was posted. This is called a dynamic named range.tbl is defined range create via following formula
Data is the worksheet name. Typically, that might be Sheet1.data is the worksheet name that contains table data