Thanks for your code...
i used that code in file sample.xlsx.
on execution it calls for location of file Test.xlsx
after selection of file Test.xlsx from directory
Nothing happens in file sample.xlsx

Please note the sheet names
Data to be copied from Sheet1 of Test.xlsx ( to seek from certain directory)
Data to pasted in sheet name "Dell" of sample.xlsx. ( Active Workbook)