How would I go about making a script to automatically find and select today's
date when I activate the worksheet (not the workbook)?

I have dates in row A and I want to search for today's date and
automatically go that cell when I click on the worksheet's tab. The
worksheet is called "Order Fulfillment".