|Without knowing the exact layout of your worksheets, it's hard to give a specific answer.|
2 options come to mind:
1 - In each supplier worksheet use either VLOOKUP or INDEX-MATCH to pull supplier specifc data into each sheet.
2 - Use a macro to transfer the data once it has been entered. If you choose the macro route, then macros will need to be enabled on each user's system, something that has to be done at the user's workstation by the user or by someone authorized to perform that action. You can not "force" a system to enable macros without user interaction. That would be a serious security risk.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.