Need a little help populating in Excel
<p>So I've spent the past two days trying to learn enough VBA script to automatically populate a spreadsheet when a new one arrives from a supplier via a macro. Long story short, I haven't yet figured it out. I am now using this formula <code>=IF($A$1="", "", INDIRECT(CONCATENATE("'[",$A$1,"]Tester'!A12")))</code> to update cells after copying the new sheet into my workbook and placing the name of the new sheet in row A then copy and pasting the new formula below the old entries. Unfortunately the "Tester'A12" part of my formula is not increasing with the cell number of my columns (i.e A12 does not turn into A13, A14, etc.) I was wondering if anyone knew a way I could fix this. I may be missing something super simple. Thank you for your time!</p>