One Click UPDATE using VBA or Excel Functions

[Psionicrnd]

Hello...

Is is possible to Update the master sheet with data from sub sheets in one click? Let us say we have one Master Sheet and Three sub sheets with name A, B, C. I would like to have excel function on Master sheet or Update button on Master sheet by which if i click on that it should copy all data except labels from A, B, C to Master sheets and also while copying one column should get auto filled based on from which sheet the data been copied. For example- If 10 data copied from A sheet on column X should show A, if data is copied from B, it should show as B...and so on..Hope its not much confusing. Sorry I am not an expert in such matters..ty

 

[Psionicrnd]

Marking it CLOSED as I posted the same question somewhere else. I cant delete this post as I dont find any suitable option to do so....Ty and I apologise