Solved: VBA to find a value and copy values from sheet2

[richardSmith]

I have worksheet1 which contains the ComputerNameListed and worksheet2 which contains the user information. What I want to do is search worksheet1 for each instance of ComputerNameListed (it always starts with ComputerNameListed - (Actual name here) and when ComputerNameListed is found go to worksheet2 and find in column A the matching PC Name.

Part 2, I then need to copy the ROW from worksheet2 with the matching ComputerNameListed over to worksheet1, but past all the values from the ROW into one cell.

I was putting together some VBA to perform this, but realize I am out of my league! I was working on the find function which I have something like this:
[vba]
Set c = .Find("ComputerNameListed*", lookin:=XlValues)
[/vba]

How would one perform these tasks in vba?