Automatically copy data entered on four sheets into one Master sheet

Hi

I have an excel document which is essentially one large action tracker.

Each 'tab' is as follows and represents the Master sheet (which should automatically have all data entered from the other sheets columns A-M inclusive) and then each other sheet is for each individual meeting.

I have designed it so columns A-M in each sheet are the same headers and will contain the same information - anything individual to a meeting which will not be on the master sheet is column M onwards.

The idea is that people can update their own actions in the individual sheets, and these will automatically transfer to the Master sheet for columns A-M only, from which I can collate data and see a master overview of everything.

My question is, how on earth do I get the data from each of the sheets to the master?!

Tab 1: "Master"
Tab 2: "Implementation"
Tab 3: "Validations"
Tab 4: "Governance"
Tab 5: "Line 2 and 3"
Tab 6: "Subcos"

I am Ok with pasting code into Visual Basic if required.

any help hugely appreciated!

Hi Glenn, thanks for your reply.

Unfortunately, each sheet is quite different and has tens of other columns that would not be relevant to the master sheet.

The idea of the master sheet would be to collate all of the key indicators that each meeting has in common, and the rest which are not relevant to all meetings are after column M and can still be viewed if required - The master sheet would be a collation of the common data fields only.

Hope that makes sense, but open to any simpler ways of doing things!!