Hi I imagine this must of come up before and there must be a solution
that already exists somewhere.

I regularly receive multiple workbooks or workbooks with multiple
sheets that need to be combined to one file to produce a list of
addresses etc.

curently I manually sort them to a standard layout and have VB scripts
of my own that will then combine either the books or the sheets
(mainly books).

I would love to have a soloution that will automatically combine these
sheets into one file removing the human error factor of getting one or
more out of sequence.

Points to note:

The data layout can change and may or may not include the same number
of fields/columns

I would rename the header in each book/sheet to be consistant (only
way i can see something working)

so in summary what i need is something that will arrange the books/
sheets into the same order and i can then combine them with the code I
already have.

Or something that will arrange and combine them.

I could simply do this with access by importing each file into a
standard table but it runs the risk of missing or duplicating a file.

Any info on a solution that exists or where to start programming one
would be of great help