Need macro to make master list

[TeresaG]

I'm assuming I need a macro because I cannot find any easy way to create one masterlist of all the items in many worksheets.
The Columns are labeled the same in each worksheet. Have tried consolidating but that is taking a lot of time. I could copy and paste from each worksheet but like I said there are MANY worksheets. Also, if possible I would like to have the worksheet name included for each item in the worksheet but it is not currently showing on the page. Basically I get a list that includes each check issued and there is a tab created for each date that the checks are issued. I would like a masterlist that shows all the checks and the dates paid, paid to, amount and check number.
I do not have any experience with macros but have been able to find out to use VBA and copy and paste the information to get it done.
Any help is greatly appreciated.2014 Bills-Test.xlsx
Teresa

[Mumps1]

Hi Teresa. Try the attached file. Click the button on the "Master" sheet. Does this do want you want?

[TeresaG]

Thank you so much! This worked perfectly!

[Mumps1]

My pleasure.