Workbook & worksheet combining

[jutah]

Hello,

I have regularly use the workbook & worksheet combining macro below.

I was wondering if it would be possible to edit it in some way to make the macro only combine certain tabs that the user would specifiy the name of.

As an example, I have about 60 workbooks all containing 4 tabs and wish only to combine the tabs within each workbook called 'red report' is this possible??

Please Login or Register  to view this content.

Thanks for taking the time to read through my query.

[ravishankar]

[Hi
Try deleting the codes 1 & 2 & 3 and replace sheetnumber with "red report" in 4 & 5

Please Login or Register  to view this content.

ravi