Solved Linking multiple workbooks to one workbook

I have five team workbooks, each set up with up to 15 employee names in colum A, employee tasks set up on row 6, c6-m6, with dates as the worksheet name (Nov 26, Nov, 27) etc. The workbooks are title with the team name and a two week date and there are ten dated worksheets per workbook.

I need to take every employee name with all of the entries and move it into another workbook so tasks can be compared for each employee. The new workbook will also be set up with ten worksheets, named by the date.

The data will be changing so it has to be updated on the combined workbook every time I open it. Can someone please help?

Wait, DerbyDad, I have the same problem but was looking for two different solutions: the first time, I asked about scripting and when no one said anything, I took that to mean that no one with any VBA experience could help.

Then I asked about Linking, which, if I understand it correctly, is an Excel command, something that requires no scripting, just selecting cells from different work sheets? Isn't that correct?

re: "when no one said anything, I took that to mean that no one with any VBA experience could help."

It probably just means that no one with VBA experience had the time right then and there to respond. We're all just volunteers here and dedicating a large amount of time to a question only happens when someone has the time.

Linking is really nothing more than a formula:

- Links within a sheet:

In B1 put =A1

- Links between sheets:

In Sheet1!B1 put =SHEET2!A1

- Links between workbooks:

In '[Book1.xlsx]Sheet1'!$B$1 put ='[Book2.xlsx]Sheet1'!$A$1

If Book2.xlsx is open, you'll see ='[Book2.xlsx]Sheet1'!$A$1 in the cell.

Yes, that was helpful, DerbyDad, thanks! And clicking between workbooks was easier than typing it in.

Do you know of anyway you can do that with multiple cells? Like if I wanted column A, A2-A15 to move to another workbook, B2-B15, I tried selecting the cells, hitting = then selected the cells with the data and only the first cell populated.

The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.