Pulling off Data from website into excel

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: 

Hi,
its just that this is a Secure (private)Web site and will require a user name and Pass to enter .So I am not sure if that can help--however I have provided the page address for the start page. Let me know if there is something else that can be done? https://tec.cleardmanager.com/Login....2fDefault.aspx

Like I mentioned I have been able to get through the Site Login screen with the help of the code from JP . but I am still searching for a way to pull a value from the excel sheet and look it up on the website automatically.

HTML Code: 

Works good upto here, but cant get the code to work below

' click a button on the next page
Sub try()
Set ElementCol = appIE.document.getElementsByTagName("INPUT")
 
' loop through all 'input' elements and find the one with a specific value
For Each btnInput In ElementCol
    If btnInput.Value = "" Then
        btnInput.Click
        Exit For
    End If
Next btnInput
 
' loop until the page finishes loading
Do While appIE.Busy
Loop
 
' click a text link on the page after that
Set ElementCol = appIE.document.getElementsByTagName("a")
 
'For Each Link In ElementCol
    'If Link.innerHTML = <strong>Clickable Text Link Name</strong>" Then
        'Link.Click
       ' Exit For
'    End If
'Next Link
 
' loop until the page finishes loading
Do While appIE.Busy

Loop

'Do  Events

 
' grab some text from the body
strCountBody = appIE.document.body.innerText
lStartPos = InStr(1, strCountBody, "Text to find")
lEndPos = lStartPos + 12
'TextIWant = Mid$(strCountBody, lStartPos, lEndPos - lStartPos)
 
' grab the whole screen &amp;amp;amp;amp; paste into Excel
'appIE.ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DONTPROMPTUSER
'appIE.ExecWB OLECMDID_COPY, OLECMDEXECOPT_DODEFAULT
 
'Workbooks.Add
'ActiveSheet.Paste
 
Application.ScreenUpdating = True
appIE.Quit
End Sub

Hi

I have attached the Excel file and the .MHT(update.zip file attached) of the webpage, The excel file will list the REFERENCE # and that needs to be inputted into the reference input on the webpage. once the display button is clicked the information is provided (if the order is completed or not along with the delivery date) that needs to be put back to spreadsheet into the columns provided.

Bump.. Would appreciate any ideas on this thread ..