Looking for a VBA Macro to be able to extract data from Odyssey or JIRA to Excel - all data with the data from the history tab and other data fields properly formatted etc.
It's bit too difficult to help you without any details.
But if it's Jira try their API (REST API v2) to connect and extract data.
Then again, it's proprietary software and most of us will not have access to it. You may have better luck asking in Atlassian's support forum. https://community.atlassian.com/
As for Pantheon Odyssey (I assume that's what you meant)... I've no experience, but their website indicate you can integrate it with Office without coding.