Fill down into merged cells without skipping rows

I have the same problem as in this thread. I have tried using the solution posted by Ron Coderre, but didn't fully understand what it was I was meant to be doing. So, if there is a way to achieve what I want, I'd prefer it.

My merged cells are not purely aesthetical - each merged cell (covering 6 rows in total, beginning at A3:A8) has colums and rows to the right for other details/formulae relating to that specific merged cell (which contains a customer account name).

The list I'm trying to reference is on a seperate tab - 'Projects' starting in cell A4. This list will have project names added to it, so I need my merged cells to reference the list, and subsequently pulling through all new additions to the list, rather than having to add them on a 2nd time.

Thanks in advance.

Anyone? Having added more rows into my file I'm still doing this manually and updating each cell reference in the formula - there must be an easier way!

Thank you for your reply, but as you will see from my original post that links to that exact thread, I did already try the solution posted there, but my lack of understanding meant I was no further forwards - hence creating this thread and linking back there.