It is not usual for orchestral pieces to follow a story-though pieces like "The Steadfast Tin Soldier" have individual segments like "Piano Concerto No. 2" and so on. The Sorcerer's Apprentice is what is known as a tone poem - where different emotions are expressed by an overall story - in this case Goethe's poem, The Sorcerer's Apprentice.