Want to create a summary sheet with variable number of worksheets in a file

Hello all,
I am using Excel 2013.

I am working on creating a summary page, for a file, and would like to use a macro for it. The file itself can range in the number of sheets that are in it, and the sheet names can vary as well.

What I would like the macro to do is add tab names to column A of the "Results Summary" page, starting in cell A5. I would like the macro to go through the sheets and paste any values in column A that start in cell A4 or higher. Number of values can vary, per sheet. I would like these to be pasted in column B of the Results Summary page.

I also have formulas already entered into the summary sheet. The rows with the tab name will serve to summarize the content below them, which is contained in that sheet.

The attached file shows how I would like the results summary page to look, after I have run the macro.
Please feel free to ask any questions, as I may not be clear in certain areas.

Your help is appreciated, in advanced.

Thanks,

AWexcelHelp.xlsx

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)