Recorded Macro returns Run-time error '1004'

You do not have Table15 in other sheets so to do it as easy as possible, change

Range("Table15[[#Headers],[Column1]]").Select

to

Range("G1").Select

and below

Range("Table15[[#Headers],[Column2]]").Select

Range("I1").Select