Formula in VBA -- formula is too long

[macrorookie]

Evening -
I closed an earlier post where I don't believe I explained myself clearly, and I believe my post was in the wrong section. Apologies for the confusion.

I'm having a heck of a time finding a simple solution to my problem.

Problem:
In the attached sample workbook, starting with cell E2 I would like to show a list of the unique values shown in columns A,B,C and D. I plan to record this formula into a VBA/macro, and while the current array formula that I'm using works outside of VBA, it is too long for VBA (e.g., VBA has an array character limit of 255).

Any clever solutions?

Thanks for the help!