I have routine that updates previous workbooks by copying sheets within the
new workbook and getting the old sheet information.

Everything works great, but for some reason after more than 45 sheets are
copied it errors out.

Some of my workbooks contain over 100 sheets.

Is this a memory thing or limit thing?