excel - How to compare values in a range of cells to all worksheet in another workbook?

Question

On a source workbook, I have multiple sheets with names that are also in a range of cells in another workbook/sheet

How do I compare the two values(worksheet name in the source vs a value in the range in the destination) so that when the condition is true, a cell will be copied from the source worksheet to the destination workbook/sheet.

question from:https://stackoverflow.com/questions/65896815/how-to-compare-values-in-a-range-of-cells-to-all-worksheet-in-another-workbook

Answer 1

Waitting for answers