Creating a Summary Data from Multiple Worksheets

[dreamwarden]

Hi All!

I'm still trying to learn how to create macros and would need your help in making one.

The scenario is, I need to come up with a tracker workbook containing the sheets below and deriving its values from another workbook with multiple sheets:
1. Summary
2. Stage 28 Tracker
3. Key Indicators

Summary sheet will derive it's values from multiple projects separated into different sheets. All project tabs have the same formatting but for the summary sheet, I would like to transpose the cell values from rows to columns in accordance to the project defined in Column A. (e.g. project 1 tab has stage 1, 2,3 etc as rows and Status, MKT, Schedule, etc as columns but the orientation will be reversed in the summary sheet since all the projects will be identified in Column A).

For Stage 28 Tracker, the values will also be derived in the project tabs and would be similar to the summary sheet. the only difference is stage 28 has sub-stages which should be considered as separate entries or rows in the worksheet.

For the Key Indicators sheet, it will derive it's values from the Summary sheet but would need to satisfy certain conditions.

I'm attaching a file as it would be easier to visualize the macro I would like to create. Is this feasible?

Hoping to hear from you guys.

Thank you!