Hi Debbie,

You can not gather information from workbooks which are stored in different folders (left parenthesis, it is possible with VBA). Assuming when you created all your data, the files where in the same folder, followed by moving wb1, wb2, etc. to different folders. Right?

Shall I show you the VBA way (do you know what I am talking about?)?