Macro to pull data for a specific date range

you'll need to elaborate a bit more, that could mean any one of a dozen different things.

Ideally post a sample workbook showing the data held and what you're looking to achieve.