In general, you can a process similar to this:
write a SQL query to extract te 15 columns (you can schedule this to be run daily using a SQL Server Agent job):
SELECT [Order Number], [Order Line], [Customer Reference], -- Include other required columns FROM NavisionTable
Use Power Query to connect your SQL database to Excel.
To maintain your manually entered values, use a lookup mechanism.
Set schedule on Power Query to automate the process.
As an alternative, I am working on a project where we are building AI Agents to automate data processing operations, such as data extraction, and it's compatible with Excel, SQL, CSV, PDF, TXT, Email. If you think that might be useful for you, you can contact us via our website: https://www.starnustech.com/