Macro to Open a file, transfer data, save and close

Okay - I realize that excel is not the best place to do database type work - but it's what we have and work is not about to change it.

I am not a VBA expert by any means and google is my friend when it comes to helping determine the code needed to create a macro.

What I have now is multi macro, formulated file containing multiple spreadsheets that is used for creating sale documents. The workbook is formulated all using defined names so it doesn't matter if things move lines etc.

So what I want is to set up in this file a command button so that when it goes to the sales coordinator they click the button and it will open and specific file - find the last row and populate the columns - if it was a simple copy and paste it would be easy enough to do but the data comes from various places within the workbook. I then want the work book to save and close but that I can handle without a problem.

Hope I have given enough information

If you have some basic code to help with this it would be greatly appreciated.

Thanks