table & chart
 

Hi everydody,
I've a probleme to do my chart (with vba) by using many tables having sames
columns.
What i mean?
i'm explain:
i've 4 tables on 4 diferents sheets: F1,F2,F3,F4
these tables have 2 same columns: the firs & the last, but they are
diferrents colums on each other

example:

sur F1: année|c1|c2|c3|ref
sur F2: année|c1|c2|c3|4c|c5|ref
sur F3: année|c1|c2|ref
sur F4: année|c1|c2|c3|c4|c5|c6|c7|ref

how to copy these table on a sheet:F5 and do the chart by using data on
sheet F5 by using vba
Please
Francky