How can I convert an Excel Macro to html or use the database in a webpage?

I am pretty decent with HTML+CSS (and I have used JavaScript and PHP with lots of google support) but recently I have been taught how to make Excel Macros at work (essentially alot of vlookups, format tables, and pulling data from web sources). What I want to be able to do is place the data/table online for others to use while continuing to pull data from my sources. Any ideas, tips, or how to’s?