I have a problem regarding cell reference. I wanted to get the data from the other tab which I already got the row number and the tab name for each.

The tab name will then be cleaned up using MID and FIND to output the correct Bundle number

Expected output will be 2,3 and 4.

This is coming from below.

https://i.sstatic.net/bRhGCdUr.png

Also, I will attached the file here: https://docs.google.com/spreadsheets/d/1ikAH6-NKHBL9piJ4nJY_hyLdTjtPbi2VK7Ct1kIFelg/edit?gid=1255002068#gid=1255002068

If you can help me with this that would be great.