cell below find

Hey, I currently got an assignment (well more like a request from my dad, but it's for company use so.) He asked if I could make a program that retreives certain values from (different) sheets in one workbook, and export it to another one, eventually automaticly creating a graph with the data...