Copy data from workbook selected in combobox (recieving object error)

I am trying to have my Workbook copy the data from another workbook. The workbook to copy data from is based on the selection from combobox1, which lists all open workbooks. After the selection is made, my macro to copy data will run.

When I run the macro, it opens the combo box and I select the data I want copied and click “OK”. After I click “OK”, it runs the sub named “ClearandPullStatsinArray1”. However, I get a “no object defined” error when it is running this sub.

I cannot figure out why. Screenshot below. Thank you for your help!

USER FORM:

Please Login or Register  to view this content.

IN ANOTHER MODULE:

Please Login or Register  to view this content.

I tried that and got the error "Invalid attribute in Sub or Function" and it highlighted the word "Public" in the "ClearandPullStatsInArray1".

Please Login or Register  to view this content.

I do not have any experience with userforms or combo boxes so I got my code for the Userform from this thread here. Does this help? Could you suggest some code to use if this is wrong for what I want.

I have figured it out. Thank you for your help Mike!