Copy Data From Multiple Workbooks to One Workbook

I am trying to copy data from multiple other workbooks (in this example, just one wother workbook- "Machine Charting Entry.xlsm" ) into one main workbook ("OEE Charting.xlsm"). All of the data in the 'other' workbooks is layed out the same way as in OEE Charting, but has varying lengths of data. The problem that I am having is from an error when I try to paste the code into OEE Charting, there is an error "Object doesn't support this property or method" and I cannot find a way to fix it.

Please Login or Register  to view this content.

I have also tried using .range(cells(2,1),cells(LastRowMCE,27)).paste, but it still returns an error.
Am I referencing the main workbook incorrectly?
Thanks in advance

This is not making any sense:

Please Login or Register  to view this content.

With an "With ... End With" one expects a phrase which begins with a dot. For example, if you are referring to cell A2 in the worksheet "Enter Data" then:

Please Login or Register  to view this content.

Range with a dot before it (and nothing else before the dot) goes with the With statement.

Also, try PasteSpecial instead of Paste.

With:

Please Login or Register  to view this content.

You should then have a statement like:

Please Login or Register  to view this content.

As it is:

Please Login or Register  to view this content.

doesn't make any sense, because you need a worksheet (or sheet) statement between a workbook and a Range.

I finally got it to work, thanks for the help!