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

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!

No, I am technically looking to copy the downloaded data (1 sheet worth of data) once copied, I would like to paste it as values to a specific workbook and within the workbook a specific work sheet. Ideally in certain cells like B3

the work book I would like the data to be copied to will be opened at the same time as the downloaded one. if is could be closed or opened that would be ideal also.

With the cells, for example, in the downloaded workbook the data will be in a1 to g8 but I would like to have the option to save the data to an other cell when pasted IE b3 h10.