I am trying to resolve this issue with Pulling data of a website . I can get into the site with VBA code
however I need to access a tab called "Client" which needs to be selected and then on the page add the value from excel sheet I am searching for into an input box named "referenceNo" and then download the result back into Excel whatever the Option value is either "completed or other"

I am adding the script from the soource page.

HTML Code: