I have five different files in one folder with few tabs in each of them
tabs name share same name
Can we create macro that first search tab name in all five files and than pull data of specific range to each table in master file. tab name should be drop down
tabs name share same name
Can we create macro that first search tab name in all five files and than pull data of specific range to each table in master file. tab name should be drop down