How to pass a Parm to the Query

How to pass a Parm to the Query

I have a sales sheet.  The Devart Qry brings in a table SMB_Budget.  I want to filter that table on a salesman (smb_salesman).   Is this possible, and if so, what is the approach I should use?   The salesman number will be in a Cell in the excel spreadsheet for the user to select and refresh.  It would  need to be passed to the query.