12 Worksheets that are similiar in look and dynamic -> Want to create 1 master

Hello Everyone -

I was wondering if someone had a generic macro I could use:

I have 12 worksheets. I want to create 1 master worksheet. The 12 worksheet look identical, but the dates might change, or text for the activities might change.

The master sheet - should combine in order from tab 1 to 12. I would like a button to update the master sheet with the new data.

Let me know if more detail is needed - look forward to hearing responses.

more detail is needed. How do you want the master to roll up the individual tabs? Need to see how data is set up.

something like...

Please Login or Register  to view this content.

I tried the code above and it only copied only a few rows. I was hoping we could add a button to the summary tab to update the tab with all new information. Do we need to build a loop?

that is a loop. It takes the information from each tab and pastes it to the master tab. So each time you run the master will update. It copies A4:BJ28 from each worksheet and pastes that to the master tab

Hmm I keep getting a run time error 1004 - any ideas?

Hmm I keep getting a run time error 1004 - any ideas?

attach file

attached -

I basically need the script to combine all 12 tabs, starting with 1 -> 12.

I would like to have a button to created to run a update whenever needed.

I really appreciate it! Ive been going nuts on trying to figure it out

Two things. First, move your code to a module (insert->module) instead of keeping it in the sheet. Second, change "TEST" to "Test"..has to tie exactly to the name..caps and all.
I edited the code for you so now everytime you run it it will delete all the contents on the Test tab and then pull in the updated information

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

THANKS! It worked!

How do I limit this code to the first 12 tabs? and not all active tabs?

Also another twist - if I have links that connect information from the first 12 tabs with tabs outside of the first 12 - how can we run the macro by copying whats in the cell of the first 12 tabs and not the link in the formula? Because the macro runs perfectly, but 1. limit data to first 12 tabs, and copy whats in the tab and not links ...

Please specifay which code you are referring to?

From the one you created.

to copy values only

Please Login or Register  to view this content.

The above line is currently on one line and change it in to separate lines

Please Login or Register  to view this content.

As to the limit of sheets you wanted to include or exclude you need to show me which sheets you want only(12 sheets).
If you juste wanted 12 sheets out of 100 or so, give me the sheet names.

Sheet names are:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.

I will go ahead and try your suggestion up above.

Sheet names are:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.

I will go ahead and try your suggestion up above.

Ameded code post no 13(Attached).
The code now only merge 12 sheets and copy values only. If you add any sheet, it will not be merged.

If I choose to add text to the 1. 2. 3. 4. ...etc?

Is it just an easy update to the code and tab? duplicating the same language?

If you update the sheet tab names, you need to do the same with the array J-names. J is the refelection of tabs names
.If I knew the pattern of your sheets, I would have approached it differently, but for now use the above code and when your demand change, I can adjust it accordingly.

quick question - how do I adjust the code to keep the formatting the same? like column size etc?

Including like column and row formatting. The goal will be all tabs look the same.

When I click the button right now, it copy and pastes but the rows and columns are so large.

I appreciate it!