Macro to Pull Last Value in a Column to a Summary Sheet Along with the Sheet Name

[ToochieMoochie]

I need help creating a macro for trust sheets in excel. In the excel document I have many sheets (at least 170) with the same basic layout. I have attached an example excel document for reference. Each sheet has the same number of columns, but the number of rows vary.

In reference to the macro:
1. I need it to pull the values from the last used cell in column F from each sheet into a summary sheet.
2. I would like the summary sheet to have the name of the sheets referenced in column A and the value from the last used cell in the corresponding column B.
3. From there, I should be able to imput formula to get a grand total of all the trust sheets.
4. Then, I will be able to compare that number to bank statements to ensure that my trust sheets are up to date.

I have little experience in excel, so please be as detailed as possible.

Thanks in advance.

[alansidman]

Here is your VBA solution and a file to review.

Please Login or Register  to view this content.

[ToochieMoochie]

Thank you so much! It worked perfectly.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.