I am a newbie in this forum and I'd like to say Hi to everyone.

I have a weekly sales register that I wish to link to an annual monthly register. My problem is that the data doesn't appear on the monthly register when the source weekly workbooks are not open. I used 'indirect' function.

Please help me, thanks!