Excel-SQL Sync Automation

I need a small, reliable system that lets me keep a few chosen sheets from my master Excel workbook fully in sync with SQL Server 2019. A single button click in Excel should: • push any new or updated rows to SQL • pull any changes from SQL back into the same sheets Conflict handling must always keep the newest version of a record. To make that possible, add a hidden date-time stamp whenever a row changes so the macro can decide which side is fresher. Behind the scenes, use MERGE/UPSERT logic to preserve primary keys, treat NULLs, dates, and numeric types correctly, and avoid duplicates. What I expect delivered • a macro-enabled workbook (.xlsm) with clean, commented VBA and Power Query steps • SQL scripts that create or adjust the target tables and indexes • an error log that lists any rows that fail to sync and the reason • a concise hand-over PDF so my analyst can maintain or tweak the solution later You may work in Windows 11 and Office 365; those match my environment. A first working build within a couple of days would be ideal so we can test quickly.