paste charts across multiple worksheets

dear friends,

I have an xls workbook with 100 worksheets, each named for one employee. All the worksheets have 5 similar tables with data. whilst the tables and headers are similar, the data varies from employee to employee. I wish to insert similar column charts besides each table - across all 100 worksheets. Is there a way of doing this at one go - ie without having to insert charts manually into each worksheet, beside each table?
While I can use 'ctrl' to change tables across all sheets simultaneously, same function is not active for 'insert - chart'. Please help.

yours

dear ryan,
thanks. pl see attached xls with sample worksheet for 1-3 employees. i would like the charts to be pasted across all the worksheets, but at the moment, when I copy and paste the first worksheet, and change the data for each employee, the charts do not change accordingly. hope that is clearer.

dear andy,

i am a very basic xls user. can u pl explain further. currently i have a list of 100 employees in column A of 'data' worksheet, with a button 'create pages'. when i press the button, worksheets with names from colum A in 'data' are created. i have manually filled data into each table in each worksheet by copy-paste from a pivot table.
what do i need to do to use your code to enable charts to appear in all 100 worksheets beside the table from the template in 'employee 1' worksheet? or should i create a 'master worksheet'?