Automatically transfer data from all sheets in a work book to a front master sheet.

Hi Everyone

I have produced a worksheet document that my engineers will fill in whilst collecting data out in the field. What I want to do is gather this information from each sheet when it is returned to me.
My intention is to add all the returned sheets into a workbook and have a data gathering sheet as the front sheet. I have never done anything like this before so everything is basically suck it and see or is there a simple command (set of) that i can follow.

Thanks in anticipation friends.

Hi Dave,
This can be done via VBA for sure. If you can provide a few things it will help people along with your request.

A sample sheet of what the engineers send back to you
and
A sample of what the master front sheet will look like along with any other needs for the sheet.

If it is a large undertaking, I'm not sure how quickly someone will help, but something is better than nothing

How do I attach my work book?

Yes Pepe thanks I will spend a little time reading and have a go.
My how do I attach was in reply to nemo74 before I read your message
Thanks Dave

Originally Posted by nemo74

Hi Dave,
This can be done via VBA for sure. If you can provide a few things it will help people along with your request.

A sample sheet of what the engineers send back to you
and
A sample of what the master front sheet will look like along with any other needs for the sheet.

If it is a large undertaking, I'm not sure how quickly someone will help, but something is better than nothing

I want to issue the service sheet to the engineers who will complete onsite and send back to me, I want to check each individually (Manually) then will copy as a sheet into this workbook. My intention is to use the Mite asset No as the sheet name. I only need the yellow cells copying across. I obviously need each sheet be mapped to the next aavilable line. Is this possible ??Replacement Data Gathering.xlsx

Thanks Pepe Le Moko, with a little re-organising of my service sheet and following the guidance you provided. I have managed to do what I required, this is the first time I have ever really manipulated data this way and it worked after a little trial and error.

Thanks Again Dave