excel vba - Copy information from variable sheets to sheet1 -

i'm not sure begin, have found codes finding information , selecting information can modified. i'm not sure how begin start string need new vba.

i begin explain current "macro1" does. have 2 main sheets in excel, first "template" , other "log". "macro" copies information "template" sheet , pastes on "form" after has created new row. copies it's self , renames sheet value "a1". reassigns macro button (macro2).

over time have multiple sheets macro2. i'm trying have macro2 copy information in cell range on active sheet "log" sheet. needs find cell "a1" active sheet , replace information.

any pointing me in right direction greatful.