Hi.
I'm trying to create a sheet that automatically inserts data from other sheets that are continuously added to the workbook. This means that I do not know the number of sheets or the names of the sheets that are to be displayed on the overview sheet.
The data ranges could be something like A3:F6 for sheet1 to sheetn, and I would like them to be inserted below the previous sheet.
I'm want it to look something like this:
Sheet 1
sheet1!A1 .. .. .. .. sheet1!F1
.. .. .. .. .. ..
.. .. .. .. .. ..
.. .. .. .. .. ..
.. .. .. .. .. ..
sheet1!A6 .. .. .. .. sheet1!F6
Sheet 2
sheet2!A1 .. .. .. .. sheet2!F1
.. .. .. .. .. ..
.. .. .. .. .. ..
.. .. .. .. .. ..
.. .. .. .. .. ..
sheet2!A6 .. .. .. .. sheet2!F6
..
Sheet n
sheetn!A1 .. .. .. .. sheetn!F1
.. .. .. .. .. ..
.. .. .. .. .. ..
.. .. .. .. .. ..
.. .. .. .. .. ..
sheetn!A6 .. .. .. .. sheet2!F6
I'm guessing that I'm going to need some VBA coding for this, but I can't really figure out how since I am very new to that stuff.
Is it possible in any way to do this? And how exactly?
Thanks in advance![]()
Bookmarks