Macro For Importing HTM Report Data

trying to do anything other than the basics with Excel. I would like creating a macro to import data tables contained in a report that I receive in HTML format.

The Report looks like the following. I de-identified the data

VRAAPCO1 VER 8.1 VANMANDY ADMINISTRATOR
PAGE 1 01201010 CONNECT SUMMARY CPU 046E16
REPORT DATED: JUN 12, 2012 17:53
INFORMATION AS OF: JUN 11, 2012 23:09

EXTRACT FILE(S) USED:
DDName=SVSAM DSN=SYSL.VRA.SVSAM.EXTRACT
DDName=MVSAM DSN=SYSL.VRA.MVSAM.EXTRACT
MASKING CRITERIA: MGROUP=FSCSC OR MGROUP=FSCORE OR MGROUP=FSTECH OR MGROUP=FSBSM OR MGROUP=FSCCS OR MGROUP=FSEMFE OR

[Code] ........

The column group represents a security profile for an application. I am auditing the access to that application. They either start with the '#' symbol or the '@' symbol.

I receive this report once a quarter. This being my first time. I had to manually cut and paste the data tables from the HTML report file into a spreadsheet.

This is what I would like to be able to do in excel using VBA. The report name is the same every time. 'FS.ASET.Users.htm'
1. Would like to create excel spreadsheet with a macro button and master worksheet that already has the headers.

Group Userid User Name Owner Create Date Special Operations
Auditor Revoked ADSP GRPACC UACC Authority

2. That looks in a network directory(will be the same everytime) for this htm file(will be same name every time)

3. Pull only rows that start with # or @. Place them into single worksheet with sorted by 'Group' ascending.

4. A stretch goal would be to have the macro create a different worksheet within the spreadsheet for each profile name, I.e.,@UFSGUAR, #ZCBSAU, and copy only those rows that start with that profile name into each subsequent worksheet.