Resolved Question: VBA Excel: How to loop inactive workbooks and loop the worksheets for each while returning the worksheet names?

I need to prepare a summary worksheet in a different workbook. So far I manage to select and return the folder path in a cell. But how can I loop the all workbooks (and so does the worksheets in each) by just referring to the folder path which was in the cell (say cell:= B2)?

I need help on including conditional formula in For Each... loop.

Thanks in advance :)