Get data from several tables at the bottom of "master" table

I have several employees who photograph many clients (sports teams) every week, and I'd like to have all their data in one customer database. So what I basically have is several tables (who are all the same) and my own database, which expands every week depending on how much clients the photographers had.

There are two problems:
1) I'd like to have the adding to my table more or less atomised, not that I have to open 50 files (of 50 employees) and copy/paste them at the end of my table, every week.
2) My own table has more columns, so every column of a photographer must be assigned to a different column of my table.

To get it a little more tentative, the employees' columns are something like this:

1) Date

2) Employee

3) Client

4) Price

And I have something like

1) Enumeration

2) Date

3) Employee

4) Client

5) Status

6) Price

7) Profit

So how do I get all the rows of several employees at the bottom of my table, and in the right column?

Here's a sample file, I've put the one of the photographers's weekly database in a second sheet. The references/lookups of the main sheet don't work now because I've deleted them.

Thanks a lot in advance!

why not attach a sample file ?

a good sample file has the original structure with dummy data, not without data

Hi, Stormbringer,

do all sets look like the given example? If so you may add all informtion from every column in any sheet (preferably all files are located in one folder) to your mayin workbook You could utilize an Array stating the column numbers into which to copy the data like

Please Login or Register  to view this content.

and loop through the columns to copy (please mind that the array starts with 0).

HTH,
Holger

Hi, Stormbringer,

the code posted is for copying the contents of one workbook which will be opened for this. Code for a standard module:

Please Login or Register  to view this content.

You may try the code by pressing ALT+F8 but you need to enable macros for doing so.

Ciao,
Holger

Hi, Arthur,

I'm afraid I don't know how the reference to the data-file (Freelancers.xlsx) is made, I can't recognise it in your code either so I can rename the files if necessary.

With activated macros a box should appear where you may make your choice which file to take. There is no hardcoded reference to any file except to the file holding the code. Please check the seuroty settings and allow macros to run.

Ciao,
Holger