VBA Function: Filtering a Dynamic Array

I'd like some help creating a VBA Function.

Specifically, I need to create a VBA function which goes into a column within a dynamic array and then provides a list of unique fields in a seperate worksheet.

Any advice would be much appreciated.