Do some Excel Work -- 2

I run a music label, my business model is creating and releasing music albums in bulk – as many as possible - and I want to streamline the process of creating metadata for these albums in Excel, making it as efficient and automated as possible. As an example - if we are releasing an album called “Album XYZ”, which contains • 20 tracks with unique track names and unique ISRC codes for each track (E.g. UK-999-00-99999), • a unique barcode for the album, e.g. “5555555555555” • a unique catalogue number for the album, e.g. ABC100 (which means it is the 100th album we released) • a release start date at least several days in advance This album would have a unique metadata spreadsheet where each of these unique values would have to be populated into the appropriate column and the appropriate number of rows -.e.g. in the above example the unique barcode will need to be in the “Barcode Column” and take up 20 rows. The file name should be the barcode number. I take the barcodes, catalogue number and ISRC codes from a google docs spreadsheet and mark off the ones that I use. I then take 20 track titles from a spreadsheet of a few hundred track titles on a separate spreadsheet and populate the “Track Name” column, and then mark these off. I am after ideas, guidance and a program/script/etc that would therefore automate the process as much as possible. I can send example spreadsheets for reference if you get in contact, and also clarify any questions you may have. Thank you.