Generate a single report from multiple spreadsheets in one workbook

Hello to all,
I have 24 sheets as part of my Workbook.

I need to extract a "report" that summarizes the following information:
The text information in column A1 of all the sheets, the date from the LAST entry in column E from all the sheets, and the numerical (dollars) data from the LAST entry in column F from all the sheets.
I would need to have the final result appear as three columns with each column showing the data as described above from all of the 24 sheets.
Can someone please show me how a macro could be constructed to perform that task?
Thank you.
Regards.

Could you upload a sample file

Hello again,
Attached is the spreadsheet as you requested.
I sincerely appreciate you taking the time to assist me.
The data is just bogus information but it makes the request clearer.

I'd need to generate a report that:

• Shows the name as shown in cell A1 (it is text)
• Shows the LAST (most recent) entry is column E (it is a date)
• Shows the LAST (most recent) entry in column F (it is a dollar amount)

The final report needs to look something like this:

NAME DUE DATE MIN AMOUNT DUE
Blaze - Account#9129 9/22/12 $50.00
Capital - Account#4388 9/24/12 $75.00
..etc...etc...etc...from all sheets in the workbook.

Thank you again!
Regards.

Hi, the way the code works is that for every sheet, it scrolls through column J to assess how many active rows there are and assigns the last active row in the set of data based on that. Are there empty cells in column J within the data range?!

Hello,
Yes to your question regarding column J.

The reason for this is as follows:
Data entered in column G is what triggers the result in columns I and J.
However, entering information in columns E and F may take place weeks before data is entered in column G.
The reason data is in columns E and F is to act as a reminder that there are scheduled bills to be paid.
When the scheduled dates get close, THEN the bill is paid and data is finally entered in column G and, therefore, column J then gets its data.

The idea of the summary report that you have written is so the user can run it at anytime as see what bills are pending (not yet paid).
Therefore, there will regularly be data in columns E and F but no data in column G (and therefore, no data in column J).

Whee. I sure hope that was clear.
I'm sorry to be causing you so much work and effort.
I appreciate you still taking an interest in my request.
Thank you again.

Hi,
Changed the code a little bit. Should do the trick. Could you test the enclosed file and let me know if it works

Hi,
Yes. It appears to function as I described it you.
I'm amazed that you were able to follow my convoluted logic.
I only tested a few sheets and a couple of cells but all looked correct.
It is 3:40am here in New Jersey and I have a meeting in 3 1/2 hours so I must get some sleep.
I'll go through it completely tomorrow and report back to you.
Thank you gain!
Your patience is amazing
Regards.

Hi,
Yes. It appears to function as I described it you.
I'm amazed that you were able to follow my convoluted logic.
I only tested a few sheets and a couple of cells but all looked correct.
It is 3:40am here in New Jersey and I have a meeting in 3 1/2 hours so I must get some sleep.
I'll go through it completely tomorrow and report back to you.
Thank you gain!
Your patience is amazing
Regards.

Hello,
I've tested the new code you sent and all seems to function as I had requested.
I will send it on to my family member who needs this type of tracking system.
My thanks to you for your time, effort and expertise.

I hope you'll be available in the future when I get into trouble again!
Regards and thank you again.

My pleasure

Thank you.
I was unsure how that was done.
I'll remember it for the future.
REgards.