Collect Tab information to create a main list

Status
Not open for further replies.

CR9596

New Member
Joined
Aug 3, 2018
Messages
2
I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the formula =(tabName)!(cellNum) and it does what its needed. The problem is that I have to set a number of rows. If I set it to list 10 and if the tab they add 20 then the main list will not reflect it. I also have to name every single tab name. Does anybody know a different way for this to be done?

Below is the example. First table is the main list(end result). Second table, Alphabet Studies its a tab example where the user will be entering the data. Third table, Drawing table its another tab for entry data.


<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>




















Studies typeGroupIDCity1City2City3City4City5City6City7City8City9City10RegionMember's NameMember SinceCompanyTitleAddressCityStateZipEmailPhoneGroup President Name:Group President City Loc.:Group President Phone Num.:Group President Email:Group Tresuare Name:Group Tresuare City Loc.:Group Tresuare Phone Num.:Group Tresuare Email:Secretary Name:Secretary City Loc.:Secretary Phone Num.:Secretary Email:
Alphabet StudiesABC.DEx0x00x0000SouthBatman Guy28642xyzBusiness Relationship123 ABC StreetHollywoodCA77788bat@xyz.com888-123-4545John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Alphabet StudiesABC.DEx0x00x0000South westRobin Hood32070123CEO345 Stree CSeatleWA55236rb@123.com888-123-4546John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Alphabet StudiesABC.DEx0x00x0000NorthSamuel Clements1797BluebirdMarketing specialist987 L. house StreetHelenamt58964sc@bluebird.com888-123-4547John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Alphabet StudiesABC.DEx0x00x0000CentralLaura Ingalls40490FordData entry23B Detroit Lanejefferson cityMO56894li@ford.com888-123-4548John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Drawing StudiesDFG.ZY00x00xx0xxSouthJackson River65167Yellow stoneBusines ManagerArizona StreetHollywoodCA77788jart@yellow.com888-123-4549Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouth westSusan Salter31956Civil WarSales RepresentativeL StreetSeatleWA55236ss@cwar.com888-123-4550Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorthMary Hays1797Hilton Inc.Business Relationship95 beach house Streetsan franciscoCa58964mh@hilton.com888-123-4551Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxCentralAlan shepard40490Hershey'sTeacher85 Rio AvenuecordobaAL56894li@hersheys.com888-123-4552Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouthRobert Frost28642ZooAnimal Control930 Pluto LaneHartfordCt77788bat@zoo.com0Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorthJohn Hancock32070Football hallCoach867 Alaska St.OrlandoFL55236rb@football.com888-123-4554Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorthLewis Clark1797Cardinal techField tech.494 Golden GateHelenamt58964sc@cartech.com888-123-4555Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxWestJames Cook40490cherokeeSales Representative23B Detroit Lanejefferson cityMO56894li@cherokeecom888-444-5555Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouthEli Whitney28642National parksDirector of plants123 ABC StreetHollywoodCA77788bat@nationalparks.com0Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorth eastWalt Disneyh32070health technologiesNurse Tech.345 Stree CSeatleWA55236rb@flower.com211-555-8854Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxEastNoah Webster1797Flower deliveryGardener987 L. house StreetAtlanta GA589640211-555-8855Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxEastCody Bill40490Bird AcademySales Representative23B Detroit LanemaconGA568940211-555-8856Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxCentraljames marshall28642TelegraphNetworking administrator123 ABC StreetCharlotteNC25368sc@telegraph.com333-999-889Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouth westWilliam Seward32070innovations technologiesWeb specialist345 Stree CTampaFL78989li@InnoTech.com333-999-890Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com

<thead>
</thead><tbody>
</tbody>




<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

























Alphabet Studies City1City2City3City4City5City6City7City8City9City10
GroupIDABC.DECityx x x
Name:City Loc.:Phone Num.:Email:
Group PresidentJohn DoeHawaii123-444-5555jd@att.com
Group TresuareJack Brownsydney111-222-8888jb@abc.com
SecretaryMiss Acanada888-999-888ma@net.com
RegionMember's NameMember Since dd/mm/yyyyCompanyTitleAddress CityStateZipEmail Phone
SouthBatman Guy6/1/1978xyzBusiness Relationship123 ABC Street HollywoodCA77788bat@xyz.com 888-123-4545
South westRobin Hood10/20/1987123CEO345 Stree C SeatleWA55236rb@123.com 888-123-4546
NorthSamuel ClementsDec-04BluebirdMarketing specialist987 L. house Street Helenamt58964sc@bluebird.com 888-123-4547
CentralLaura Ingalls11/8/2010FordData entry23B Detroit Lane jefferson cityMO56894li@ford.com 888-123-4548

<thead>
</thead><tbody>
</tbody>



<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>


































Drawing Studies City1City2City3City4City5City6City7City8City9City10
GroupIDDFG.ZYCity x xx xx
Name:City Loc.:Phone Num.:Email:
Group PresidentJefferson WilliamsSpringfield888-444-5555jw@text.com
Group TresuareKen FrankfortIdianapolis211-555-8888kf@indiana.com
SecretaryMiss BDayton333-999-888mb@jackson.com
RegionMember's NameMember SinceCompanyTitleAddress CityStateZipEmail Phone
SouthJackson River6/1/2078Yellow stoneBusines ManagerArizona Street HollywoodCA77788jart@yellow.com 888-123-4549
South westSusan Salter6/28/1987Civil WarSales RepresentativeL Street SeatleWA55236ss@cwar.com 888-123-4550
NorthMary HaysDec-04Hilton Inc.Business Relationship95 beach house Street san franciscoCa58964mh@hilton.com 888-123-4551
CentralAlan shepard11/8/2010Hershey'sTeacher85 Rio Avenue cordobaAL56894li@hersheys.com 888-123-4552
SouthRobert Frost6/1/1978ZooAnimal Control930 Pluto Lane HartfordCt77788bat@zoo.com
NorthJohn Hancock10/20/1987Football hallCoach867 Alaska St. OrlandoFL55236rb@football.com 888-123-4554
NorthLewis ClarkDec-04Cardinal techField tech.494 Golden Gate Helenamt58964sc@cartech.com 888-123-4555
WestJames Cook11/8/2010cherokeeSales Representative23B Detroit Lane jefferson cityMO56894li@cherokeecom 888-444-5555
SouthEli Whitney6/1/1978National parksDirector of plants123 ABC Street HollywoodCA77788bat@nationalparks.com
North eastWalt Disneyh10/20/1987health technologiesNurse Tech.345 Stree C SeatleWA55236rb@flower.com 211-555-8854
EastNoah WebsterDec-04Flower deliveryGardener987 L. house Street Atlanta GA58964 211-555-8855
EastCody Bill11/8/2010Bird AcademySales Representative23B Detroit Lane maconGA56894 211-555-8856
Centraljames marshall6/1/1978TelegraphNetworking administrator123 ABC Street CharlotteNC25368sc@telegraph.com 333-999-889
South westWilliam Seward10/20/1987innovations technologiesWeb specialist345 Stree C TampaFL78989li@InnoTech.com 333-999-890
333-999-891

<thead>
</thead><tbody>
</tbody>
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,745
Office Version
365
Platform
Windows
Duplicate https://www.mrexcel.com/forum/excel-questions/1066408-collect-tab-information-create-main-list.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.
 
Status
Not open for further replies.

Forum statistics

Threads
1,085,589
Messages
5,384,624
Members
401,913
Latest member
chethan av

Some videos you may like

This Week's Hot Topics

Top