Making contact list form multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3347058%22%20slang%3D%22en-US%22%3EMaking%20contact%20list%20form%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3347058%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20make%20a%20contact%20list%20from%20multiple%20sheets%20that%20we%20use%20for%20different%20trades.%20All%20the%20contact%20information%20is%20in%20the%20same%20cells%20on%20each%20sheet.%20I%20am%20wanting%20to%20add%20a%20sheet%20at%20the%20end%20that%20will%20pull%20all%20the%20information%20in%20to%20use%20as%20a%20directory.%20Examples%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22BradyBrazell_0-1652129248267.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370329i0ED6FAA308ECDC29%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22BradyBrazell_0-1652129248267.png%22%20alt%3D%22BradyBrazell_0-1652129248267.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ETrying%20to%20get%20info%20put%20into%20this%20format.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22BradyBrazell_1-1652129356767.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370330i5DE70267DD166AAA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22BradyBrazell_1-1652129356767.png%22%20alt%3D%22BradyBrazell_1-1652129356767.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3347058%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3349147%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20contact%20list%20form%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385204%22%20target%3D%22_blank%22%3E%40BradyBrazell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20I%20recommend%20to%20provide%20more%20information.%3C%2FP%3E%3CP%3EYou'll%20get%20a%20quicker%20and%20more%20accurate%20answer%2C%20and%20those%20who%20want%20to%20help%20don't%20have%20to%20invest%20time%20guessing%20the%20problem.%3C%2FP%3E%3CP%3EI%20recommend%3A%20Always%20inform%20about%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2Fhard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%3C%2FP%3E%3CP%3EIf%20possible%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20project%20step%20by%20step.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20forget%20that%20not%20every%20Excel%20user%20has%20a%20clue%20about%20every%20job%20and%20what%20you%20see%20he%20can't%20see.%3C%2FP%3E%3CP%3EIn%20this%20link%20you%20will%20find%20some%20more%20information%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3EDrag%20and%20drop%20here%20or%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Freplypage%2Fboard-id%2FExcelGeneral%2Fmessage-id%2F145794%23%22%20target%3D%22_blank%22%3Ebrowse%3C%2FA%3E%20files%20to%20attach%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EMaximum%20size%3A%2071%20MB%20%E2%80%A2%20Maximum%20attachments%20allowed%3A%205%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20solution%20suggestion%20with%20the%20possible%20integration%20of%20hyperlinks%20that%20might%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHYPERLINK%20function%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWork%20with%20links%20in%20Excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20or%20change%20a%20cell%20reference%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20information%2Flinks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3357142%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20contact%20list%20form%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357142%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385204%22%20target%3D%22_blank%22%3E%40BradyBrazell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20you're%20an%20insider%2C%20but%20this%20request%20is%20something%20TOCOL%20and%20WRAPROWS%20were%20made%20to%20handle.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20all%20you'd%20need%20(This%20sample%20has%20the%20data%20going%20down%2030%20rows)%3A%3C%2FP%3E%3CP%3E%3DWRAPROWS(TOCOL(Sheet6!A1%3AD30%2C1%2C1)%2C5)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I am trying to make a contact list from multiple sheets that we use for different trades. All the contact information is in the same cells on each sheet. I am wanting to add a sheet at the end that will pull all the information in to use as a directory. Examples below. 

BradyBrazell_0-1652129248267.png

Trying to get info put into this format. 

 

BradyBrazell_1-1652129356767.png

 

 

 

2 Replies

@BradyBrazell 

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step.

 

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5
 

Here is a solution suggestion with the possible integration of hyperlinks that might help you.

HYPERLINK function

Work with links in Excel

Create or change a cell reference

 

Hope I was able to help you with this information/links.

 

NikolinoDE

I know I don't know anything (Socrates)

 

@BradyBrazell 

I don't know if you're an insider, but this request is something TOCOL and WRAPROWS were made to handle.

 

This is all you'd need (This sample has the data going down 30 rows):

=WRAPROWS(TOCOL(Sheet6!A1:D30,1,1),5)