Consolidate multiple user's data from different sheets to single master excel sheet.

[ebineg]

Hi Everyone,

I am trying to figure out a way to consolidate multiple user's data from different sheets to single master excel sheet using Macros.

Eg:
.
user 1 selects particular rows and once macro is run, these data should automatically get pasted in the last empty rows in master excel sheet which is in shared path (shared sheet will be a master sheet that holds all the user data).

same case should be able to perform by multiple users.

Thanks in advance.

 

[ebineg]

Any help on this is highly appreciated!