MS Projects - Macro that grabs certain tasks from subprojects into master

Question

I am looking to build a Macro in MS Projects and am trying to hash it out conceptually first. Any help would be great.

I ultimately want a master project to show each sub project by means of each section.

I currently have 3 devices that each have 3 sections, and they all have the same 3 sections but different tasks in each.

Each section is basically a nested task schedule specific to that device.

For instance:
Green Device
Section 1: Acquisition (nested task schedule for green device)
Section 2: Contracts
Section 3: Logistics

Blue Device
Section 1: Acquisition
Section 2: Contracts
Section 3: Logistics

Red Device
Section 1: Acquisition
Section 2: Contracts
Section 3: Logistics

Again, each device has the same sections, but have different schedules from eachother.

I want the master to show:

Master Schedule
Section 1: Acquisition
Green Device: Acquisition part only
Blue Device: Acquisition part only
Red Device: Acquisition part only

Section 2: Contracts
Green Device: Contracts part only
Blue Device: Contracts part only
Red Device: Contracts part only

Section 3: Logistics
Green Device: Logistics part only
Blue Device: Logistics part only
Red Device: Logistics part only

//

I am looking for the Master Project to be generated by the macro and be "static" and not linked to the sub-projects. I would like each engineer of each device to control their respective device's project schedule. And when I want to see them all together, I want to generate the master schedule by running the macro. I dont want the master schedule to change the sub projects at all, essentially not dynamic.

Any thoughts?

I am sorry to say that I am not experienced with VBA, however, I am trying to set up the conceptual pseudo code type of language for clear communication.

Basically, I am wanting to stich subprojects together by means of their respective sections.