How do I automatically transfer data from one Excel report to another?

Hello to whomever is reading this.

I'm assuming this will require macro programming which I've never done before. Does Microsoft Office 2010 support Python 3 (and other language) macros or just VBA? Also, how does VBA differ syntactically from the "normal" (.NET and pre-.NET) Visual Basic? Does VBA have the exact same syntax as the pre-.NET Visual Basics (that is, versions 6.0 and earlier)?

Also, is "recording a macro" basically doing things graphically and having Office make the code for you behind the scenes?

Any input would be greatly appreciated!

Hello, thank you for your answer and, about your comment saying the title not matching my post, sorry, I was sleepy when I wrote the post so my thoughts must of been all over the place.

Since then, I've done quite a bit of research and I've come up with the following macro which doesn't run successfully. Just to say, WorkBook1.xlsm and WorkBook2.xlsm are in the same folder and they each have only one work sheet.:

Please Login or Register  to view this content.

The Microsoft Visual Basic compiler says:

Run-time error '424':
Object required

and suggests that the

Please Login or Register  to view this content.

syntax is what's at fault.

I'm thinking that I need to make an object for a clipboard or something so that I can run that operation but I'm confused as to how I should proceed from here.