Marco across sheets

[Excelexcel86]

Hi guys I have roughly 50 sheets in one workbook now each sheet has vba code where when I click the button on that sheet it opens up my csv data . The problem I have is each sheet has the same code apart from where to get the file from as they are all in different folders so is there a macro I can run on a master sheet that opens all 50 sheets for me into one master sheet . Any help much appreciated

 

[James006]

Hi,
Difficult to guess which macro you are actually using ...

But, a dead simple loop can handle your apparent obstacle ...

 

[Excelexcel86]

Hi sorry can u help me with a formula for that I don’t even know where to start I just need to have a master sheet where I run the macro and it opens all 50 sheets into one sheet. My code for all the sheets are the same apart from the path name to get the file