Have you found a solution for this question? It would help our community a lot to see a small bit of sample data to better understand the issue or maybe at least some included photos. It's very hard to suggest a solution that may not work after examing the actual data in question. There are several sample workbooks in the Workbook & Calculation Library.
Please review the article - Packaged workbooks: when, why, how created by our community of users to address how best to engage with the community.