Selecting A Column based on Cell Value
 

I have a Master Sheet (Data Insert) that is used as a form. It fills
in the corresponding worksheets based on the Date that the user inputs.
The last sheet in my workbook (Detail) is a summary of the inputed
Data sorted by Date on Row 2. I need to have it so when the user
inputs the data on the Data Insert worksheet it looks to that Detail
sheet looks for the matching Date in Row 2 Selects that column and
fills in that column.

Dim Input AS Worksheet
Dim Detail AS Worksheet
Dim sDate As Variant

Input = Worksheet("Data Insert")
Detail = Worksheet("Detail")

sDate = Input.Range("c2").Value

Now this is what I dont know how to do

Select Column From Detail Where Cell.Value = sDate

As when starting a Variable what type can be used to represent a Column?