VBA to save a newly open workbook to a specfic workbook and then sheet within

[namluke]

Hi,
Every day i download a file in an excel format.
(The file name itself and the sheet name is a different in every down load.)
I am looking for a VBA code to save the downloaded active worksheet file automatically to a specific workbook and within the workbook a specific worksheet and if possible to a specific range of cells.
For example the workbook name is call “traffic” and one of the worksheets is called “other” saving the data in B3

Can this be done?

Any help or advice would be great!