Help on VBA to extract financial data from Website

Greetings Colleagues!
I am trying to make a file where it displays financial data from this site: http://edge.pse.com.ph/companyDirectory/form.do and automatically updates into my excel file (please see attached). I am not that familiar with VBA so I am requesting some help from anyone if they can?

I have the first column with the stock codes. I need to extract data to fill in the Security Name, Close Price, Outstanding Shares, Market Capitalization and Book Value. As mentioned above, these may be extracted from here: http://edge.pse.com.ph/companyDirectory/form.do

Additionally, is there also a way that the data refreshes automatically?

Would anyone with a kind heart please assist me with the VBA for this?

Many Thanks in Advance!