I need a macro that lets me select multiple tabs in a worksheet and copy and paste the data in those tabs to another specific worksheet as values not formulas. Any help would be greatly appreciated (I can attach an example if needed).

Thanks,