No need to do that.  You can keep the data on separate sheets if you wish.  
It might be easier for you to do that but it doesn't really matter.

Example:  

If your 8000 rows are on sheet 1 and your job titles list (728) are on sheet
2.  Highlight the entire range of job titles and click Insert-->Name-->Define.

Type the name MyTitles in the field for it.  Make sure that the range is
accurate in the "Refers To" field and then click Add.  This creates your
named range.  You can then use this name in a formula.

Go back to your main sheet with the 8000 records and insert three blank
lines above your data (This tends to be the easiest method).  

Leave the first cell in the first row blank.

In the first cell of the second row, enter the formula.  For the cell
refernce (currently G2 in the formula) use the first cell containing data in
the column you wish to search.  So if on your main sheet your job titles are
in column B and the first one (not the header) is in row 8 then use B8 in the
formula.

Select a cell within the 8000 rows of data and choose
Data-->Filter-->Advanced Filter.  The "List Range" should cover your 8000
rows, make sure it does.

Click into the "Criteria" field and then highlight both the cell containing
the formula AND the blank cell above it.

If you wish to paste the resultant list elsewhere (perhaps on another sheet)
then select the option and choose where you wish to paste it.  Then click OK.

Sounds complicated but it really isn't.  Any problems, feel free to shout
again :)

DC