Much-delayed £38.6m project brings works from 1800 to 1945 together for the first time as single collection.