Thanks for your reply.

All the charts are in one excel, is it possible to do that way? Or we need to split that in different sheets?

Headers are static, we can even add that in Macro.

unable to add the attachment (may be due to the new user restrictions)