Hello XL Mac Guru's

hope you are all doing fine.

here's my requiremnts

Project A worksheet: contains values for a row stating Preparation, Design, Execution, Total
Project B worksheet: contains values for a row stating Preparation, Design, Execution, Total
Project C worksheet: contains values for a row stating Preparation, Design, Execution, Total

there are also other sheets which has other values as well..

Running a macro - hould pik the values correspondong to row's Preparation, Design, Execution & Total and display it in one single sheet. this should be done only when the workbook has any sheet starting with the name "Project..."


Many thanks for help

Regards
ManInRed