Let me start here, paulkaye: Why do you want the data describing the files to be on two separate worksheets?

Don't misunderstand me; there are plenty of reasons it'd be nice, starting with "just because I want to". But you're running into the difficulty that poses. I'm sure there are ways around it, but maybe it's simplest to start with a master sheet having all the data in one place and then figure out how to display selected columns elsewhere. Before putting much work into a workaround, I want to start by examining the basic layout.