Help making master sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1662442%22%20slang%3D%22en-US%22%3EHelp%20making%20master%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1662442%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%2050-100%20page%20workbook%20that%20I%20am%20trying%20to%20make%20a%20master%20page%20for.%20The%20first%20page%20is%20the%20master%20and%20all%20the%20data%20needs%20to%20be%20pulled%20from%20the%20other%20sheets.%20On%20the%20master%20I%20need%20to%20be%20able%20to%20sort%20each%20column.%20I%20know%20alittle%20about%20excel%20but%20can't%20figure%20out%20what%20formula%20I%20need%20to%20use.%20Need%20the%20master%20sheet%20to%20update%20when%20I%20add%20information%20on%20the%20other%20sheets....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1662442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1662670%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20making%20master%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1662670%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F792159%22%20target%3D%22_blank%22%3E%40Msdreemin%3C%2FA%3E%26nbsp%3Byou%20might%20be%20able%20to%20use%20power%20query%20to%20do%20what%20you%20want%20but%20I%20might%20also%20suggest%20you%20might%20be%20better%20served%20if%20you%20reversed%20the%20way%20you%20are%20doing%20things.%26nbsp%3B%20Make%20the%20master%2C%20your%20master%20and%20enter%20all%20the%20data%20there%20and%20then%20the%20individual%20sheets%20can%20pull%20data%20from%20the%20master.%26nbsp%3B%20In%20this%20way%20you%20may%20also%20find%20that%20you%20don't%20need%2050-100%20sheets%20because%20all%20you%20need%20to%20do%20is%20create%201%20(or%20a%20few)%20templates%20and%20then%20when%20you%20fill%20in%20which%20job%20(or%20whatever%20that%20code%20is%20for)%20that%20you%20want%20to%20see%20the%20information%20for%2C%20the%20rest%20of%20the%20data%20gets%20pulled%20from%20the%20master.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, 

 

I have a 50-100 page workbook that I am trying to make a master page for. The first page is the master and all the data needs to be pulled from the other sheets. On the master I need to be able to sort each column. I know alittle about excel but can't figure out what formula I need to use. Need the master sheet to update when I add information on the other sheets....

1 Reply

@Msdreemin you might be able to use power query to do what you want but I might also suggest you might be better served if you reversed the way you are doing things.  Make the master, your master and enter all the data there and then the individual sheets can pull data from the master.  In this way you may also find that you don't need 50-100 sheets because all you need to do is create 1 (or a few) templates and then when you fill in which job (or whatever that code is for) that you want to see the information for, the rest of the data gets pulled from the master.