How to get worksheet function to return data to other cells

I would like to write a worksheet function that returns data to other cells. One of the arguments is the starting cell location to return the data. The other arguments specify the remote data source. How can you get a worksheet function to do this. I know it can be done - I have a product suite with that includes an excel addin that does just this - but it is password protected so I cannot see the code.