Copying and pasting multiple different workbooks into single workbook using loop?

Hello,

I'm a fairly low-level noob, but with the help of this forum have been able to do (seemingly) alot. Here is what I'm currently trying to do: I am trying to copy the second sheet of six different workbooks into a single workbook and pasting them into sheets 1-6 in my new workbook. I've used a similar process before, but the code seems exceptionally long to me. I believe there must be a way to loop or something else I'm not aware of to avoid writing the code six times (i.e. for each copy and paste). Here is what I have so far:

Please Login or Register  to view this content.

..... [I do think from "Otherbooks" 3,4,5,and 6. Any suggestions on how to make this less redundant would be appreciated.

Like so:

Please Login or Register  to view this content.

Please don't forget to use code tags, I've added it to yuor post above. Take a moment to read through the forum rules (see link above).