How to Sort Rows by dynamically determining first and last row

I have a worksheet that has a few rows of header information. I'd like to give those rows a name of "DashboardHDR".
I'd like to locate the FIRST ROW after that named range of rows.
Then I'd like to locate the final row by looking in column B for BLANKS and then the previous row is the LAST ROW.
Then I'd like to sort from FIRST ROW to LAST ROW, ascending, on the value in column F.

Bonus Question: Column F header value is "Work Type". The last row in "DashboardHDR" contains the header text. Would it be possible to designate the sort column by locating the column associated with header text = "Work Type"?

I have to give full disclosure ... I am not an Excel programmer. I am a programmer (C, assembler/mainframe, pltpf/sabrtalk, VBA). I've done some VBA coding for Access, but fully self-taught. So, I have a little knowledge and know what I want to do ... a dangerous combination.

My goal: create a macro and a button on the worksheet to sort the detail rows on the sheet by a particular column, regardless of how many rows of detail data there is.

Thanks, in advance, for any assistance.