Macro to copy several worksheets to new sheet capturing latest data

[alitanna]

I have a workbook made up of sheets showing delivieries scheduled - they are broken up on tabs depending on what the source of the product is. Deliveries are added to all tabs throughout the day.

We want to copy these tabs all onto one sheet and sort by date so we can see daily deliveries no matter what the source is. My macro only captures the data I use to set the macro up - how can I set it up to get everything to the last row entered on each tab?

thanks for any help - new to this forum. hope I'm posting correctly.
ali

[JBeaucaire]

AS per forum rules, this thread was moved to the appropriate forum.

=======================

Can you post this macro you created? Be sure to add code tags around the code.

Even better would be the actual workbook itself. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix. Use BEFORE/AFTER sheets if that helps make it clearer.