For Each Next Assistance on Copying data from Multiple Worksheets

[AlvaroSiza]

I have worked through the search forum and actually incorporated a portion of RoyK's code from a like-kind thread, but can't seem to get it going. I appreciate the assistance.

Ultimate Goal:
- Click Event imports tabular data from 5 worksheets from a user-chosen source workbook and pastes to next available row + 1 (x1up + 1) in destination workbook.

Here is my basic import code:

Please Login or Register  to view this content.

And here is the code I pulled from RoyK in another thread that utilizes the for each next:

Please Login or Register  to view this content.

I need help incorporating the for each next such that it pulls the range of A1:L62 from each of the 5 worksheets and pastes them either (I don't particularly have a preference)

1. Into 1 worksheet - such that each next worksheet range is pasted below the previous + 1 row; or
2. Into 5 worksheets

Thanks!!!

[AlvaroSiza]

Following up...

RoyK's solution won the day. I did have to rename the worksheet name to its actual name

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Here is the code in total. Hope this helps someone else upon search. Thanks Roy!

Please Login or Register  to view this content.