Keeping number static in a dynamic enviorment
 

The situation that I have sounds simple but for the life of me I can't
figure it out.
What I have is an excel sheet with multiple tabs named after certain
customers. I have been able to export the numbers that I want to copy
over to a single sheet on my main excel sheet. Now I can't figure out
how to attach that sheet to there specific cells in the tabs for the
customer, because the problem is this. Let's say I have A,B,C for now
but the next time I run the report a new number was added to replace B
so B got move to C so I than would have A,B,C,D. This would mess up
any formulas that I have connected to the originals and it would throw
off my references. Is there any way in VBA Excel that I can do to, so
I do not have to constantly audit the form for new entries? Any and
all help would help. Thank you in advance.