Without any other info the only suggestion is to see if your sheets
have different names.
For example, a statement like:

Sheets("Feb Sales").Cells(i, j+5) = k

might cause a 1004 error if the new workbook does not have a sheet with
this name. Otherwise you need to post the code.

HTH
Kostis Vezerides