You moved a summary file that was updating without issues until last month to a different location along with its folder. Or ...
After updating Power Query, the total sales were nearly double what they were last month—and there were no errors at all.
A simple setup lets Excel combine recurring reports and refresh the results whenever new files arrive.