Trying to finish a VBA code to copy cells from multiple workbooks and worksheets

I am trying to copy cells from multiple workbooks and worksheets. The worksheets are all identical, except for an "Instructions" worksheet. Currently, I have a code that can pull the cells from multiple workbooks, but only one worksheet. Alternatively, I have found a few codes to gather the cells from all the worksheets, but only one workbook. I am having trouble combining the codes to copy the cells from all workbooks and worksheets (my VBA experience is limiting me).

Here's what I have:

Please Login or Register  to view this content.

That code copies in the cells I need for all the workbooks in the directory, but I don't know how to change the sheet name to reference all sheets. I have tried adding this code, but it does not work:

Please Login or Register  to view this content.

This is odd...I copied your code in and changed the file location, but when I ran it nothing happened. No error, but still a blank worksheet. I'm trying to see if I did something wrong...