Stop Migrating Your Spreadsheets. Kill Them.
The 47 spreadsheets are renders of objects you never built — so they drift. Consolidating just makes sheet #48. Find the five or six real objects your shop runs on, build those, and let the sheets become disposable views you generate and throw away. Why that just got cheap enough to do.