I need help automatically filling a column with data from other sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1156758%22%20slang%3D%22en-US%22%3EI%20need%20help%20automatically%20filling%20a%20column%20with%20data%20from%20other%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156758%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20extremely%20grateful%20to%20anyone%20who%20takes%20the%20time%20to%20look%20into%20this%20for%20me.%26nbsp%3B%20I%20am%20working%20on%20a%20productivity%20tracking%20spreadsheet%20for%20my%20team%20members%20to%20use%20in%20the%20workplace.%26nbsp%3B%20We%20are%20using%20Excel%20via%20Google%20Drive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETask%3A%3C%2FP%3E%3CP%3EI%20need%20to%20automatically%20populate%20columns%20of%20information%20on%20Sheet%20D%20based%20on%20information%20entered%20into%20corresponding%20columns%20on%20Sheets%20A%2C%20B%2C%20and%20C%2C%20as%20the%20data%20is%20entered%20on%20sheets%20A%2C%20B%2C%20and%20C.%26nbsp%3B%20Number%20of%20entries%20per%20sheet%20is%20a%20variable%20number.%26nbsp%3B%20I%20want%20to%20avoid%20having%20to%20manually%20copy%20the%20previous%20day's%20information%20into%20the%20collective%20sheet.%26nbsp%3B%20The%20goal%20is%20to%20be%20able%20to%20have%20individual%20sheets%20for%20data%20entry%2C%20and%20a%20collective%20sheet%20that%20shows%20all%20of%20the%20data%20entered%20into%20those%20individual%20sheets.%26nbsp%3B%20Then%20use%20that%20collective%20data%20to%20generate%20weekly%20and%20monthly%20stats%20automatically.%26nbsp%3B%20I%20just%20need%20help%20figuring%20out%20the%20%22collective%20data%22%20sheet%20problem%20i'm%20having.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%3A%3C%2FP%3E%3CP%3EI%20can%20manually%20copy%20the%20information%20from%20the%20individual%20sheets%20into%20the%20%22collective%22%20sheet%20but%20I%20have%20to%20do%20this%20daily%20and%20it%20has%20to%20be%20done%20at%20the%20end%20of%20each%20work%20day.%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20simplified%20solution%20via%20Functions%20if%20one%20is%20available%2C%20but%20I%20am%20familiar%20with%20VB%20and%20Macros%20as%20well%20so%20those%20solutions%20are%20helpful%20too.%26nbsp%3B%20Please%2C%20any%20help%20or%20insight%20is%20appreciated.%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1156758%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1156867%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20automatically%20filling%20a%20column%20with%20data%20from%20other%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156867%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F547914%22%20target%3D%22_blank%22%3E%40mparamonte%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20combination%20of%20Tables%20and%20Power%20Query%20plus%20PivotTables%20with%20measures%20could%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am extremely grateful to anyone who takes the time to look into this for me.  I am working on a productivity tracking spreadsheet for my team members to use in the workplace.  We are using Excel via Google Drive.

 

Task:

I need to automatically populate columns of information on Sheet D based on information entered into corresponding columns on Sheets A, B, and C, as the data is entered on sheets A, B, and C.  Number of entries per sheet is a variable number.  I want to avoid having to manually copy the previous day's information into the collective sheet.  The goal is to be able to have individual sheets for data entry, and a collective sheet that shows all of the data entered into those individual sheets.  Then use that collective data to generate weekly and monthly stats automatically.  I just need help figuring out the "collective data" sheet problem i'm having.

 

Problem:

I can manually copy the information from the individual sheets into the "collective" sheet but I have to do this daily and it has to be done at the end of each work day.

I am looking for a simplified solution via Functions if one is available, but I am familiar with VB and Macros as well so those solutions are helpful too.  Please, any help or insight is appreciated.  Thank you!

1 Reply

@mparamonte 

Perhaps combination of Tables and Power Query plus PivotTables with measures could help.