Combine Data From Multiple Sheets in Excel (VBA) -- 2

Hi

I need VBA code to combine data from multiple sheets into one, based on "parent ID". For example if on Sheet 2 is data that related to Sheet 1, and on Sheet 3 is data that is related to Sheet 2, I need those data combined on Sheet 4 in "Tree View Mode", like:
Sheet 1 Data
- Sheet 2 Data
- - Sheet 3 Data
- - Sheet 3 Data
- - Sheet 3 Data
- Sheet 2 Data
- - Sheet 3 Data
- - Sheet 3 Data
- - Sheet 3 Data
Sheet 1 Data

Sample of how data should be combined is on Sheet named "combined" (all Sheets should be combined there). Also first row on Sheet "combined" shows the correct order of data columns that should be copied from other Sheets.

COPYING ALL DATA FROM ONE SHEET AFTER ANOTHER IS NOT A PROPER WAY TO FINISH TASK!
PROPER WAY IS DESCRIBED ABOVE AND PRESENTS ON THE SAMPLE OF SHEET "COMBINED".

If you have any question - please let me know

P.S. Before posting your proposal - please make sure that you'll be able to finish project and, please, make atleast small part of code that properly combine data.

Thanks

Link to file - https://mega.nz/file/z9BWwJgK#ucR1I4DOeXLjs_NbMjZlV2YFu7N4M_Z8smuS9VYR7BQ