VBA to copy a sheet from a workbook into another workbook that is closed

Okay so I'm trying to figure out how to create a data collection template that will have a button (Let's call it Workbook A). When the button is used in Workbook A, it will copy one sheet that has data and input the sheet into another workbook (Workbook B).

There will only be one workbook B and many workbook As. There will also be many users so I don't want the users to have to open workbook B in order for the data to be sent there. And I don't want the sheets to be overwritten every time a new user adds their sheet from their version of Workbook A. I want them all to collect in workbook B.

I don't even know if this is possible with VBA and my experience with VBA language is limited to Googling how to tinker with existing macros.
Does anyone know if it's possible and if so, can you give me an idea of where to start? Everything I've looked up has been incredibly confusing and/or ended up not being what I was looking for.