VBA Dynamic Data From Access And Static Data In Excel?

I am using the statement

Code:
Sheets("Sheet1").Range("A6").CopyFromRecordset rs
to populate columns A through to F. These records come from an Access database.

In column H through to L, content is being written for each record.

For example columns A to C are dynamic and H to I are static

A
B
C
H
I

1
Record 1
Some data 1
Some data 3
Manually entered data 1
Manually entered data 3

2
Record 2
Some data 2
Some data 4
Manually entered data 2
Manually entered data 4

The problem is when a new record is added to the database. It creates a new row for columns A to F however the data for H to L does not move. The same occurs when a record is deleted from the database.

A
B
C
H
I

1
Record 0
Some data 0
Some data 0
Manually entered data 1
Manually entered data 3

2
Record 1
Some data 1
Some data 1
Manually entered data 2
Manually entered data 4

3
Record 2
Some data 1
Some data 1