Concatenate Formula

Please assist with following:

1) The AR 12901 tab needs to reflect the Deposit ID results from the control totals tab. I'm trying to eliminate manual input per cell since each deposit is based on a particular company.
For example, 1 means HA, 7 means HAI, 3 means HHO, 5 means HIHC, and 340B means 340B.

2) The GC 12017 & Other tab needs to reflect the Deposit ID results from the control totals tab.