Combine Multiple Worksheets Into One Summary Sheet.

[tandkb]

Hello,

I have 35 tabs that are updated daily. I want a summary worksheet that will combine everything that is on the 35 tabs. Info can be updated on these 35 tabs at anytime and would like the summary worksheet to reflect the changes made on any of the 35 tabs. Each tab has the exact same headers I just want the updated info to go into the summary sheet when someone fills it out on their tab. Does this make sense?

Thanks so much for your help!

 

[My Aswer Is This]

A few questions I have.
1. So we have 36 Tabs ?
2. What is the name of the tab where you want all this data from the 35 other tabs entered.
3. Is the Summary tab named Summary
4. So how would a Vba script be activated?

So if John enters some value in column P of any of the 35 Tabs would this be a way to activate a script to copy that row of data to the summary tab.

This would happen automatically when a value was entered into column P

Is this something like you want?

If not tell us more about exactly how you want this to happen.

Or you could double click on column A of any sheet in the workbook and that row of data would be added to the Summary Tab.

Exact details are always needed when attempting to help Users.

Please give specific details like sheet names and Column numbers.

Like sheet named "Summary" and when I double click on Column A

Do not say things like "The other sheet" or Column Data

Look forward to helping you.

 

[tandkb]

Hi, Thanks so much for helping me with this!

1. I misspoke, I have 48 tabs including the summary tab.
2. Summary is fine for the name of the "summary" tab.
3. Below are the names for each tab.
[TABLE="width: 153"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Summary[/TD]
[/TR]
[TR]
[TD]Adamsville TN Yard[/TD]
[/TR]
[TR]
[TD]Batesville Yard[/TD]
[/TR]
[TR]
[TD]Benton Wood Products[/TD]
[/TR]
[TR]
[TD]Bunker Field[/TD]
[/TR]
[TR]
[TD]Bunker Yard[/TD]
[/TR]
[TR]
[TD]Central Arkansas[/TD]
[/TR]
[TR]
[TD]Central Kentucky[/TD]
[/TR]
[TR]
[TD]East Tennessee Yard [/TD]
[/TR]
[TR]
[TD]Eastern Kentucky[/TD]
[/TR]
[TR]
[TD]Eastern Tennessee[/TD]
[/TR]
[TR]
[TD]Eldon Field[/TD]
[/TR]
[TR]
[TD]Eldon Yard[/TD]
[/TR]
[TR]
[TD]FOB BWP[/TD]
[/TR]
[TR]
[TD]FOB Illinois[/TD]
[/TR]
[TR]
[TD]FOB Indiana[/TD]
[/TR]
[TR]
[TD]FOB Michigan[/TD]
[/TR]
[TR]
[TD]FOB Morehead[/TD]
[/TR]
[TR]
[TD]Illinois[/TD]
[/TR]
[TR]
[TD]Indiana[/TD]
[/TR]
[TR]
[TD]Ironton Yard[/TD]
[/TR]
[TR]
[TD]Kentucky[/TD]
[/TR]
[TR]
[TD]Kentucky Cooperage[/TD]
[/TR]
[TR]
[TD]Linden TN Yard[/TD]
[/TR]
[TR]
[TD]Michigan[/TD]
[/TR]
[TR]
[TD]Mississippi[/TD]
[/TR]
[TR]
[TD]Morehead Yard[/TD]
[/TR]
[TR]
[TD]New Florence Yard[/TD]
[/TR]
[TR]
[TD]Northern Indiana[/TD]
[/TR]
[TR]
[TD]Northern West Virginia[/TD]
[/TR]
[TR]
[TD]Northwest Arkansas[/TD]
[/TR]
[TR]
[TD]Ohio Stave Company[/TD]
[/TR]
[TR]
[TD]Ohio Stave Field[/TD]
[/TR]
[TR]
[TD]PA Yard[/TD]
[/TR]
[TR]
[TD]Pennsylvania[/TD]
[/TR]
[TR]
[TD]Salem Field[/TD]
[/TR]
[TR]
[TD]Salem Indiana Yard[/TD]
[/TR]
[TR]
[TD]Salem Yard[/TD]
[/TR]
[TR]
[TD]Seymour Field[/TD]
[/TR]
[TR]
[TD]St. Joe AR Yard[/TD]
[/TR]
[TR]
[TD]Supervisor[/TD]
[/TR]
[TR]
[TD]Sweetwater TN Yard[/TD]
[/TR]
[TR]
[TD]Tennessee[/TD]
[/TR]
[TR]
[TD]Western KY Yard[/TD]
[/TR]
[TR]
[TD]Western Kentucky[/TD]
[/TR]
[TR]
[TD]Western Missouri[/TD]
[/TR]
[TR]
[TD]Western Ohio[/TD]
[/TR]
[TR]
[TD]Western Tennessee[/TD]
[/TR]
</tbody>[/TABLE]
4. It could be activated any way you wanted. The "best" "easiest" would be fine.

Below is the header for each tab

Location - Buyer Name - WL_XX - Check Date - Check Number - Check Payee - Check $$

I have 47 people who will each have their own tab. They will enter data into their tab and I need it to show up on the summary tab.

Right now all 47 people email me this data and it gets lost in my email. I need a way to track their check info all in one place and the summary page will help me with this.

Please let me know if you need more info or different info. I really appreciate your help with this.

Thanks again!!

 

[sandy666]

with PowerQuery aka Get&Transform Appen all 48 tabs into one table and load to Summary tab
if someone add/remove/change data on their tab just refresh summary table

 

[tandkb]

Hi Sandy,

My question with tables is I need all the info entered into the tabs to be entered in sequence on the summary tab. I feel that with tables the data will not be shown on the summary table as entered. Does that make sense? If tab 1 enters 5 rows of data and tab 2 enters 3 rows of data then tab 1 enters 1 row of data I need it to show up on the summary tab in that order.

Does that make sense?

Thanks!

 

[SpillerBD]

Hi Sandy,

My question with tables is I need all the info entered into the tabs to be entered in sequence on the summary tab. I feel that with tables the data will not be shown on the summary table as entered. Does that make sense? If tab 1 enters 5 rows of data and tab 2 enters 3 rows of data then tab 1 enters 1 row of data I need it to show up on the summary tab in that order.

Does that make sense?

Thanks!

So you have each line of data Time/Date stamped?

 

[tandkb]

So you have each line of data Time/Date stamped?

Will I need that? I could have that entered when they add data correct.

 

[sandy666]

Hi Sandy,

My question with tables is I need all the info entered into the tabs to be entered in sequence on the summary tab. I feel that with tables the data will not be shown on the summary table as entered. Does that make sense? If tab 1 enters 5 rows of data and tab 2 enters 3 rows of data then tab 1 enters 1 row of data I need it to show up on the summary tab in that order.

Does that make sense?

Thanks!

it will be in order you've added tables from tabs

 

[My Aswer Is This]

I see Sandy is helping you so I will move on and help someone else. I'm sure Sandy will have a good answer for you.

I will keep monitoring this thread to see what I can learn.

 

[My Aswer Is This]

I will get back with you.

​