How to Populate Data from a table to another

[MS001]

I have 2 tables A & B. A is a summary table and B is a breakdown of table A. I want to achieve that whatever is entered in Table A reflects in Table B.

ReSql = "INSERT INTO " & XGetListObject(Sheet1.ListObjects(1)) & "([Account?],[count of'
'invoices],[value],[Percent]) " & _'
'"SELECT [Account?],[count of invoices],[value],[Percent] FROM "'
'& GetListObject(Sheet2.ListObjects(1)) & " as T2"