import html to excel sheet, apply template

Hello,

First things first, I am a VB noob. I have a c/c++ backround (even a bit of turbo pascal :eek: ) , so i am sure i can pick it up very quick.

Now what i need to do is import the contents of a html table into an excel spreadsheet, then from this spreadsheet, apply a template to create a new sheet.
In detail, I have a table for employees, where each col is an employee, and each row is a data value, i.e. age etc etc. So cell 1 in the table gets copied into cell 1 of the spreadsheet. Once the whole table is copied, a new sheet is created for each employee (column) with the values in each row for the employee as well.
I would like to have most of this process automated, mainly the copying of info, and creating of file.

Thankx for any input youmight have,
Terry