Copy rows out several sheets into one

[Dennis]

Is it possible to have a main workbook with information from other
workbooks at each worksheet? I have 20
workbooks with information. I would like to haven a main workbook with on
sheet1 every row from the
20workbooks with category1, on sheet2 every row from the 20workbooks with
category2, etc, etc. The information
in the 20workbooks in always only on sheet. The Colum in which the data is
has no fix end. I go to fill in the
rows trough a user-form and comes always under the last row.

The mainsheet has to update every time it opens (and if possible a button
on the sheet to update manually)
without opening all the other documents.

I would like to make the connexion with one subsheey an the mainsheet and
then copy the subsheet 20x with the
connexion



SUBSHEET1 SUBSHEET2 SUBSHEET3
Categorie3 Categorie1 Categorie2
Categorie1 Categorie3 Categorie3
Categorie3 Categorie2 Categorie2
Categorie3 Categorie1
Categorie2 Categorie3
Categorie1 Categorie2
Categorie1


MAINSHEET
Sheet1 Sheet2 Sheet3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie2 Categorie3
Categorie3

 

[KC Rippstein]

This sounds a bit complex to try to do without programming. You should post
this under the Programming newsgroup if you haven't already.