Cycling through workbooks

I had a crash and am having to rebuild some code. Using the example below, one area I'm having trouble with is in the "DO YOUR CODE HERE", "PsuedoCode" part. My overall operation is to manipulate pivot tables in and copy data from various files and paste into a single worksheet. My two pain points are:

1) For my first workbook I want to paste Headers and data, for the all the rest just the data. I'm looking for an elegant way to differentiate just those steps for my first WB, without having to have two really long steps that are basically the same other than headers and LastRow.
2) Instead of all the files in a folder I need to open 4 specific files. How would I plumb that into the code below?

Please Login or Register  to view this content.

Hi,
1) I would bind some flag at the beginning of code like FirstFile=0. Then in Pseudocode section I could check is it first file or not.
If FirstFile=0 then Copy header+data AND FirstFile=1 else Copy data only
All next files will go throw Else statement and copy only data. After this short IF - manituplation should be probably the same for all files.
2) If you could add some special simbols in those 4 file names you could check file name before open it.

Good idea on 1). On 2), the files aren't mine, so can't add to the filenames.

MarvinP,

That's the right solution, but unavailable to me at the present time.

MarvinP,
That's the right solution, but unavailable to me at the present time.

XlNitWit,
I'm rocking with your solution. Thanks!