Hi Gang,

Sorry a noob question here. I have created a workbook with several worksheets/tabs. Now I want to create a summary sheet so that I can get a grand total of the amounts from all the sheets. I swear I have done this before but I have pulled a major brain cramp and can not figure out what formula or what syntax I need to use to get the information into the current sheet.

So again what I want to do is pull information from one specific cell on a sheet and place that data into a cell on the current sheet.



All help will be greatly appreciated.

Keith