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

Best Regards
MIR