Hi Excel Community,
Please note I am trying to consolidate data through VBA, I am still learning regarding VBA so appreciate your help. ( Note: The solution cannot be using power query)
Basically I need to open like 12 excel files and see if the sheets("Template") (Same name sheet is in all...