Macro to "Jump to" or find data based on a data validation drop down list

Hi all!

I have been trying to write and record different Macro's to possibly help with a function I am trying to develop within a worksheet.

So I currently have a worksheet that contains a forecast table by months that displays one project on a standalone basis. Essentially the table itself is a giant sumifs/vlookup that pulls data from elsewhere in the workbook.

At the top of the forecast tab is a data validated, drop-down list where the user selects which project they would like to view. When the user selects a project a work-order number auto-generates beside it.

Is it possibly to create a macro that will essentially search for the workorder number (that is a variable parameter) and send the user to where the data is being pulled from?

The closest I came was this....

Range("$T$4").Select 'This is the cell the workorder is included in
Selection.Copy
Cells.Find(What:="801163847", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows).Activate


----Here in-lies the problem, when the macro searches within the .Find function for What=, it displays only a fixed workorder number and not searching for what is in cell $T$4.

Thanks you Neil!!

Is it possible to for the "found item" to set a print area around the project-specific table and end the macro in page break view? I again tried using relative references, but I am unable to get the macro set a print area for a "found" search item.

Range("B155:R172").Select
Range("R155").Activate
ActiveSheet.PageSetup.PrintArea = "$B$155:$R$172"
ActiveWindow.View = xlPageBreakPreview

Also, all tables are aligned within the came columns and repeat after one another. Hopefully that helps!