help referencing data from large spreadsheet to summary sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2156952%22%20slang%3D%22en-US%22%3Ehelp%20referencing%20data%20from%20large%20spreadsheet%20to%20summary%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2156952%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%2C%20detailed%20spreadsheet%20with%20data%20such%20as%20attendance%20and%20donations%20listed%20by%20week.%26nbsp%3B%20This%20workbook%20has%20a%20separate%20tab%20for%20each%20year%2C%20rows%20are%20each%20week's%20date%2C%20and%20columns%20for%20each%20week's%20totals%20and%20year%20to%20date%20information.%26nbsp%3B%20I%20compile%20current%20year%20data%20comparing%20the%20same%20week%20in%202021%20to%20the%20same%20weeks%20in%202020%20and%202019%20onto%20a%20summary%20sheet%20to%20send%20to%20our%20management.%26nbsp%3B%20How%20can%20I%20pull%20info%20from%20different%20tabs%20onto%20the%20summary%3F%26nbsp%3B%20I%20have%20tried%20a%20vlookup%2C%20but%20cannot%20seem%20to%20get%20all%20the%20pieces%20to%20work%20properly%2C%20and%20am%20thinking%20there%20is%20something%20that%20would%20work%20better.%26nbsp%3B%20Right%20now%2C%20I%20manually%20enter%20all%20the%20info%20and%20know%20there%20is%20a%20better%20way%20to%20approach%20this.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20any%20suggestions%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2156952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a large, detailed spreadsheet with data such as attendance and donations listed by week.  This workbook has a separate tab for each year, rows are each week's date, and columns for each week's totals and year to date information.  I compile current year data comparing the same week in 2021 to the same weeks in 2020 and 2019 onto a summary sheet to send to our management.  How can I pull info from different tabs onto the summary?  I have tried a vlookup, but cannot seem to get all the pieces to work properly, and am thinking there is something that would work better.  Right now, I manually enter all the info and know there is a better way to approach this.  

thanks for any suggestions, 

1 Reply

@MaryR1330 There are different ways to go about this. The best next step is to send over your file, removing any sensitive data, for us to test out different methods of how to create a dynamic reference in your Summary tab. One immediate change would be to apply a SUMIF function that changes the weeks being summed together based on the current time, to avoid having to manually sum each tabs figures.