What selection did you make on the restore dialog for the location? You need to select Restore To: "MobileSheets Storage Location" if you want MobileSheets to store all of the files from the backup under the storage location. Also, I would advise making sure that Settings->Storage->Let MobileSheets Manage my Files is enabled.
Mike
Mike