Merge similar worksheet from multiple workbooks

[Mountaineer00]

Hi,

I've searched but can't find anything that I understand. I have six workbooks with similar names, Store_Accuracy_1, Store_Accuracy_2, etc. I'm trying to copy a worksheet with similar names from each workbook into one workbook. Having a hard time understanding the language on some of the macros posted that do the same thing.

Workbooks:
Store_Accuracy_1
Store_Accuracy_2
Store_Accuracy_3

Worksheets:
Store_Accuracy_1
Store_Accuracy_2
Store_Accuracy_3

would like to get new workbook: Store_Accuracy with merged worksheets.

Workbook:
Store_Accuracy

Worksheets:
Store_Accuracy_1
Store_Accuracy_2
Store_Accuracy_3

From there I can do my analysis. It's just difficult getting the merge workbooks down. I can merge worksheets within a workbook.

Please help.

Thanks!!