sindhuja
Unfortunately I am strapped for time. I will not have internet access for the next +/- 5 weeks. (Yes, this is 2012 after all)
I am sure someone will come by and supply you with the code needed.
If not, it will be a while for me before I can finish this.

To sum it all up what you need:
1) You have two workbooks. Only one (Source) is open
2) You want to select a workbook (Master) to open with "Application.GetOpenFilename"
3) You want the total for Column AD (2 to last used cell) in Book "Source" pasted into Book "Master"
4) The pasting need to be in row 5 in the first empty cell (To the Right of the last used column in Row 5)
5) The Sheet Names are the same in both Workbooks. Book "Master" has one extra Sheet (First Sheet)
6) The totals from each Sheet in Workbook "Source" go in the same named Sheet in Workbook "Master"

Are the totals calculated already or do they need to be summed in the code?

Good luck

John