Your 'project description' seems to presuppose the existence of a userform, or at least worksheets with ActiveX controls, and a set of workbooks, one of which is called 'National', with a Summary sheet, a Combined sheet, plus eight state/territory workbooks. Without detailed knowledge of the layouts of the userform (including its command buttons, etc.) or ActiveX controls and these various workbooks & worksheets, it would be impossible for anyone to provide any meaningful code.

So, before anyone could make a start on this, you will need to provide at least the empty 'National' workbook, including its userform/ActiveX controls and the Summary & Combined sheets, plus at least one State workbook with some sample data. You can attach workbooks to a post via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.



I also can't see why anyone would specify that particular macro names (mcrImport, mcrCombine, mcrValidate) be used or that mcrImport "should accomplish the eight imports using looping", when nothing you've posted indicates why looping would be needed...

As for wanting a macro "to perform validate and summarise tasks according to the details below", given that you haven't provided any of the said details, that one's going nowhere.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you for your feedback. I attached three documents that should be able to help.
I hope they uploaded properly.

Attached Files

	National.xltm (13.3 KB, 15 views)
	WelcomeAboard.dotm (299.8 KB, 14 views)