Macros and VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1251105%22%20slang%3D%22en-US%22%3EMacros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1251105%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20automatically%20update%20one%20spreadsheet%20and%20it%20populate%20to%20the%20master%20spreadsheet.%26nbsp%3B%20For%20example%20if%20I%20have%204%20spreadsheets%20and%201%20Master%20sheet%20in%20one%20workbook.%26nbsp%3B%20How%20can%20I%20make%20changes%20or%20update%20any%20of%20the%204%20spreadsheets%20and%20the%20information%20I%20enter%20automatically%20populates%20to%20the%20Master%20sheet.%26nbsp%3B%20Please%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1251105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1251543%22%20slang%3D%22en-US%22%3ERe%3A%20Macros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1251543%22%20slang%3D%22en-US%22%3EWhy%20not%20have%20the%20information%20all%20on%20the%20master%20sheet%20and%20ditch%20the%20others%3F%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, 

 

I am trying to automatically update one spreadsheet and it populate to the master spreadsheet.  For example if I have 4 spreadsheets and 1 Master sheet in one workbook.  How can I make changes or update any of the 4 spreadsheets and the information I enter automatically populates to the Master sheet.  Please help!

 

Thank you in advance

3 Replies
Highlighted
Why not have the information all on the master sheet and ditch the others?
Highlighted

@Jan Karel Pieterse 

Ok, and maybe I'm thinking about this all wrong.  If I have one sheet and ditch the others, how would I have separate sheets for the specific information that I want to capture.  Essentially I want to have 1 master sheet, with 4-5 different sheets that were from the master.  For example:

The Master will show information for each employee.  I would like each employee to select their own respective sheets to populate information.  Any ideas?  

Highlighted
Right. But there is no fool-proof way to prevent people from accessing other people's worksheets. If that is problematic, all you can do is have a separate *file* for each individual and make sure files are ONLY made available to the correct people. With a setup like that, you can use Data, Get Data, From File, From Folder to pull in the data from the various workbooks people have filled out.