Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

How to have multiple users updating one big matrix from individual excel tabs?


I was wondering if there was a way to have three or four users typing their own information on to one tab in Excel, which then updates on to one big Matrix?
The matrix already exists and each user on this can be filtered by name. 

I would like to have each user using only their specific tab, but the information they input into that tab be all copied onto the combined user tab. 

Is this possible?




Hi Lucia and welcome to the Forum

Suggest you look at Don's tutorial here: Combine Data from Multiple Worksheets in Excel.



Thank you John. 

I want the rows to automatically appear in the martix from the users but am not looking to consolodate figures, just for it to appear in the big spreadsheet in a row underneath the other data. I don't want any cells merged, added etc, just for each tab to reproduce the data on to the matrix without interfering with the other tabs.  Is it still possible to use this tutorial to do this?
Lucia Jan 11, '22 at 8:15 am

Please edit your original file to expnd the explanation of what's need and use the Add Files... button to attach a (representative) Excel file - it's diffficult to know how your matrix is constructed without that.
John_Ru (rep: 2857) Jan 11, '22 at 8:20 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login