Hi - help needed please...

i want excel to lookup several different cells in spreadsheet and then populate another spreadsheet with them cells then save the spreadsheet - is there a way of automating this?

many thanks