Copy every opened workbook data to Main File

Hi

Seeking some one help to create VBA code for this.

Workbook A. This is my main file, this is saved in Path C:\test folder\Workbook A.Xls

First i will open this file,

then i will open another excel files example- workbook B. (This is one sample, name of the workbook is not fixed one)


Macro to start from here.

In workbook A, Active sheet to be cleared (if data already exists)
In workbook A, Active sheet objects to be deleted.
Now active worksheet of Workbook A is empty data.

Now i want to copy, active worksheet of another opened workbook (file name, sheet name whatever it may be) Example Workbook B

and paste in active worksheet of workbook A


Sample files attached

apologies sample file added now