How to do Data Validation in Sheet1 Vs Sheet2 using VBA

[apeter5]

I have sheet1 with data,

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]BL11[/TD]
[TD="width: 64"]FO204[/TD]
[TD="width: 64"]GBC[/TD]
[TD="width: 64"]PBDCB[/TD]
[/TR]
[TR]
[TD]BL10[/TD]
[TD]FO204[/TD]
[TD]GBP[/TD]
[TD]PBDCA[/TD]
[/TR]
[TR]
[TD]BL13[/TD]
[TD]FO202[/TD]
[TD]GBB[/TD]
[TD]PBDCB[/TD]
[/TR]
[TR]
[TD]BL11[/TD]
[TD]FO206[/TD]
[TD]GBC[/TD]
[TD]PBDCE[/TD]
[/TR]
</tbody>[/TABLE]

in Sheet2, Data Validation list,

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]BL10[/TD]
[TD="width: 64"]FO201[/TD]
[TD="width: 64"]GBP[/TD]
[TD="width: 64"]CLASSIC[/TD]
[/TR]
[TR]
[TD]BL11[/TD]
[TD]FO202[/TD]
[TD]GBA[/TD]
[TD]PBDCA[/TD]
[/TR]
[TR]
[TD]BL12[/TD]
[TD]FO203[/TD]
[TD]GBB[/TD]
[TD]PBDCB[/TD]
[/TR]
[TR]
[TD]BL13[/TD]
[TD]FO204[/TD]
[TD]GBC[/TD]
[TD]PBDCD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FO205[/TD]
[TD]GBD[/TD]
[TD]PBDCE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FO206[/TD]
[TD][/TD]
[TD]PBDCF[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FO207[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

By using VBA, I need to give the data in Sheet1 if only the data should be in Sheet2. Let me know if you need more details