Automatically pulling a sheet from another Excel workbook on startup

In which location is Sheet B stored? If on a network share you can use Data, Get Data, From File, From Workbook. Do this on each file that needs the information and set those resulting tables to refresh on open. (Or do it once and copy the resulting table to each other workbook in turn)