Merging sheets with different structures maintained at different granularity into a master

Hey,

I am struck up with a problem where I need to merge different sheets which have different structures maintained at different granularity into a master sheet which has all the columns available in the other sheets.

Basically I need to populate all the data present in other sheets into appropriate fields in the master sheet and leave the rest as blank because the structures are not going to be the same.

The users would fill the data in other sheets and once they are done I need to be able to populate the master sheet with corresponding values. There might be number of rows of data present in each sheet.

I have attached a sample excel with 5 different tabs which need to go into the master file.

Appreciate your help.

Thanks,
Presh