Import only a specific column instead of an entire workbook

Hi all !
I need help with importing only one column using:
Data -> Get External Data -> Exisitng Connections
In that way I can only import an entire workbook but I only need a specific column.
Is there another way?

thanks,

Shay

Hi Steve,

First thanks for the reply.
This column need to be updated all the time according to the source column automatically.
As I described, this process can be done for entire workbooks, that can be imported and update according the source workbook by "Refreshing"

Hope it's clearer,

thanks anyway.

Shay