Generating a page of "info" in one sheet from one row in another sheet

Hi!

My problem is that I will soon have a few hundred guys who will soon drop in through the door and who will need pages with different their info and such. The problem for me is that there will be about 500 guys and a few papers per guy means quite a few thousands of papers to fill in for me which would take days.

What I hope would be possible to do is to write just the info of one person in different cells on one row in Sheet1 and in the other sheets pages will be created customized for this one person.

If I for example wrote (name) John Anderson (age) 34 (born in) Florida (Closest relative) Shirley Anderson (age) 36 (phone the number) 3333333, in Sheet1 on row 5 I would in Sheet2, for example, get a page with just "John Anderson's" name in differently sized squares that will work as nametags for different equipment he'll receive, and in another sheet I would perhaps get a page filled with his medical information and details about his family, and each time I add another row with another person in Sheet1 I'd get a new page for a new person in the other sheets which would be like the first page in the respective sheets but with the new info.
So if I started off from row 1 in Sheet1 and added 500 persons I'd finally have a few other sheets with 500 pages of info about different individuals in each sheet.

Is this possible to do? Thanks in advance.

You need to separate the date entry portion from the reporting portion.

First, one sheet should serve as the "database" containing all related data and must be set up in the classic database layout described below.

First row (you may start on any row) must be a header row. Cells in the header row contain short labels descriptive of the data: i.e. Name, DOB, Address, etc.
Excample: A1 is header cell for Name, B1 is header cell for DOB, etc.

All rows below the header are "records". That is all cells under column-A contain only name and all cells under column-B contain only DOB, etc.
There must be no blank rows or blank columns. Don't use blank rows/columns to visually "space" the data - adjust row heights or columns widths

Blanks cells in a record are OK. You might not have all info initially and can back fill as it becomes available. However some cells, such as name, must have an entry.

On the database sheet NEVER use merged cells - EVER! They are the devils own invention. Avoid them like the plague.

Now, all other sheets can be "Report" Sheets that can be used for various kinds of reports, configured as needed.

Let's say report Sheet #1 is where we choose which name to report.
This may be done by typing in the name, but a better method is to use a drop down list using Data Validation (list option)

Based on the selected name, all other report sheets can be automatically filled with data extracted from the database using look up formulas.

If you were needed to report on several names or all names, a VBA macro could be written to automate this process.

Hopefully the above is enough to point you in the right direction. Can't provide more specific direction without seeing the workbooks.

Topics to explore in connection with your development:

Data Validation, Named Ranges, Look Up Functions (VLOOKUP, INDEX/MATCH).

Once you get going, post back for more help.

See attached for basic example. The workbook contain a a few named ranges and uses a drop down list on the report sheet to populate the report.