I'm new to VB and I'm having trouble with this,

I have an excel document with 30 different sheets, and each sheet contains more than 1000 rows of data.

On each sheet I want to read if there is data in ** A2, A3, A4, A5** thru the end and if this column has data then populate column AB2 by using set variable

**then take the numbers and add to the end without adding. like the example, ignoring rows without these variables.**

`TC=20, cfg=10, & BCA=50`

Example:

```
A2 contains TC9999 AB2 should say 209999
A3 contains CFG8888 AB3 should say 108888
A4 contains BCA11 AB4 should say 500011
```

Thanks