G'day all...

I have a macro that opens html pages from a specified folder one at a
time and then appends the data from each open page in a certain range
to a master sheet.

ie) range to copy from each sheet (approx 140) is A1:C100 and then
this would be "stacked" from each file to one excel file with all the
data.

Not too hard at all. What I would like to do now is grab the last word
on the title of each page and add this to the list from the range.

For example the macro opens workbook 1, grabs the data from A1:C100
and copies it to master.xls, opens workbook 2, grabs the data from
A1:C100 and copies it to the next blank cell in Column A on master.xls
and the process continues.

What I would like to add to this is that when it copies the data from
workbook 1 it also adds "1" from "Workbook 2" to each line copied, "2"
from "Workbook 2" and so on. So I know where the data came from.

Hopefully I've explained myself OK. I've tried a number of thisngs
but can't quite get it right.

Cheers all
Prometheus