Will there is a package called openxlsx which can read excel files and write them as well. But it applies to only xlsx or xls files not to xlsb files. You can read about that package and it will help you load your content from one excel as a data.frame and paste a data frame onto a particular cell in excel. I have used it for same purpose quite a lot and it works.
If you want to get data out of an xlsb file then try rodbc to get such data.
And if you want to schedule such task you try a package called task scheduler which calls Windows scheduler to run your scripts on particular time or day or date etc....