Thank you for sharing Monica.
Monica, thank you so much for creating this, this was exactly what I needed.
The only change I had to make was with step "4. Close the original data source." I used Replace Data Source to identify which fields were missing. When I selected close the original data source, I was prompted that all sheets referencing this would be deleted.
Thank you! and I am glad you found it useful
FYI You are right I inadvertently left out Replace Data Source step. I also put Close at the very end which is where it belongs..