Thank you for your reply,

The problem is the main data source has well over 50+ worksheets, which would mean you would need to have 50 separate files, which points to the right worksheet for each separate client.. (and counting as more clients come along), this of course can be achieved, creating all those files, but its not ... shall I say, a elegant solution to the problem...

But I completely agree, this is a huge monumental task or some real wizardry VBA script needed, to which I have no idea how to do...

In any case, thank you for taking the time to reply.

Regards,
Val