Struggling with a loop problem!

[tpmax]

I am creating a workbook that will be populated with data at a later time.
The data is set up to import from text files into new worksheets. Each file
will be its own worksheet. So far so good...

Here's the problem, once the data has been imported, I'd like to summarize
the data by looping through each worksheet, adding the name of the worksheet
to the first column, adding a sum of the data from the worksheet to the next
cell to the right, and then adding a parsed count function in the next cell
over.

To help visualize: In the existing workbook I'll be importing data from
files (e.g., Sample and User) which would then name the worksheets that
contain the imported data sets Sample and User as well. I'd then like to
summarize the data with line items by looping through the new worksheets,
adding the tab names in column A (e.g., "Sample" would be in A2) with the
summary calculations appearing in cell B2 and C2. The User data would then be
added to row 3. This would continue for any worksheets that had been added.

Since I don't know what the names of the new worksheets will be, I've set
the data to import into worksheets between two existing worksheets Start! and
Finish!.

Any help would be greatly appreciated!

 

[Joel]

You can loop through worksheets with the code below

for each ws in worksheets

'if you want to skip some sheets then do this
if (ws.name <> "Start") and (ws.name <> "End") then

end if

next ws