need help in automation

Hello i really need help with the file. the file was uploaded from the system. And all I really need to do is to make all the red numeric text (which is their account numbers) to be placed in line with its corresponding client name.

Notice the client name above and the red numeric text is their account number. I want it to be in-line with account name on the right side (Column B). can anyone help me provide a vba code to automatically do this and loop through the worksheets?

I really really appreciate your help. Thank you very much