Hi… Sorry for my late reply… based on my understanding, it looks like there is no dependency between the two excel files right?
If so, you try the same thing separately… Look at the workflow I shared… Does that logic work for you?
CompareSheetsData - Copy.xaml (12.5 KB)
Let me know if it works for you to achieve the purpose